Forum Discussion
Measure SWITCH with Parameter
Combined Measure = IF( SELECTEDVALUE('Category switch views'[Parameter]) = "Country", [% EE by Country], IF( SELECTEDVALUE('Category switch views'[Parameter]) = "Band", [% EE by Band], BLANK() ) )
This measure will return the measure [% EE by Country] if the selected parameter is "Country", [% EE by Band] if the selected parameter is "Band", and BLANK() otherwise.
However, the chart does not fetch anything. Should I make any changes.
3 Replies
Hi Anonymous,
Could you add a sample table and then the result you'd expect?😎Please try the following. I hope both the tables are related.
Combined Measure =SWITCH(TRUE(), SELECTEDVALUE('Category switch views'[Parameter]) = "Country", [% EE by Country], SELECTEDVALUE('Category switch views'[Parameter]) = "Band", [% EE by Band], "" )
Here is the sample Table. I have created two measure [% EE by Country] and [% EE by Band]. Now I am needing to combine this into one measure, so that if the selected parameter is "Country", [% EE by Band] if the selected parameter is "Band", and BLANK() otherwise.
EEID Country Band 1 Japan 6 2 India 7 3 Turkey 8 India Japan Turkey Parameter 4 Japan 6 Measure % EE by County 30% 40% 30% Country 5 Japan 7 Measure % EE by Band 40% 30% 30% Band 6 Turkey 8 6 7 8 7 India 8 8 India 6 9 Turkey 6 10 Japan 7
