Measure SWITCH with Parameter

[Anonymous]

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. 

[Anonymous]

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

[Padycosmos]

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

[TaylorPBI21]

Hi @Anonymous,

Could you add a sample table and then the result you'd expect?😎