Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

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() ) ) ...
Need Help
Padycosmos's avatar
Padycosmos
Solution Sage
3 years ago

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], "" )