So you can do this with the following 2 calculations;
IIF([Series name] = '"GDP ($)",[Value],0)
IIF([Series name] = '"Population",[Value],0)
When you bring these in, say with the aggregate SUM each field only contains the SUM of each measure.
Let me know if that doesn't work, or doesn't make sense.
Use case statement as below.
Case when [series name] = 'GDP' then [value]
when [series name] = 'Population' then [value] else [series name] end
Ahh yes, this worked...thanks!
Thanks for the case statement, it didn't really address the issue because its still reliant on using the Series name and doesn't provide new measure values that i could then build a dual axis graph with.