As you discovered, you can't use the Measure Names field as an option in a dashboard or worksheet action.
There are a few workarounds though...
1) Create your chart so that it makes sense to show all three of the measures at once - you can do this using a dual axis chart... see the example
2) Add a parameter to allow the user to change the measure being displayed on the chart after they have selected a country (admittedly, this isn't as slick)
3) Reshape your data so that you just have the one measure, but an extra dimension detailing the name of the measure (e.g. CPI, GDP etc) then you can use this in your table and also use it as an option in the filter action.... see example 2
Hope that helps.
Link.twbx.zip 109.6 KB
Thanks Robin. Good to see your suggestions correspond to what muddled more or less figured. I did option 1 and I think I'm ok!