Using Parameters as Slicer switch between measures

[rasalaprashanth]

Hello All,

I have a requirement to select a value and based on the selection the visual needs to switch between 2 measures

Parameter options :- (Approved, Saved) needs to be a slicer I have 2 measures show_ext_end show_ext_%

Now I need to create a measure to switch between these 2 measures based on parameter slicer Exp = if(parameter = "approved" , "show_ext_end" , "show_ext%")

[WBarberena]

Greetings @rasalaprashanth,

I used a slicer in that same way, only I used the SWITCH function instead of if/then and it worked for me:

https://learn.microsoft.com/en-us/dax/switch-function-dax

I made the following measure then assigned the slicer.

Parameter_Select =

SUMX (

VALUES ( 'Sort_Parameters'[Parameter] ),

SWITCH (

'Sort_Parameters'[Parameter],

"Parameter1", [Measure1],

"Parameter2", [Measure2],

"Parameter3", [Measure3],

"Parameter4", [Measure4]

)

)

I had multiple measures that I needed to sort, so I put them in the 'Parameter_Select' table. You may or may not need to use SUMX.

Hope this helps.