How to show specific value, when particular measure has been selected

[Anonymous]

Hi , i want to show some values in card format based on measure selection , i have tried below ones but didn't get correct output.

My values are populated using measures in UI.

and I want to detect selected measure name and show some values respective of it. As shown below. However it always show default value 4.

Test2 =

Switch ( True(),

 SELECTEDMEASURENAME()="Flag1",1,

 SELECTEDMEASURENAME()="Flag2",2,

 SELECTEDMEASURENAME()="Flag3",3,

4)

I also tried with selectedvalue , but it takes column names as input but not measure name.

As I'm new to this any help will be thankfull.

[johnt75]

You need to create a calculation group using Tabular Editor and add a calculation item which uses the SWITCH statement from your code. Apply the calculation group as a filter on the card visual.

[Anonymous]

Hi @johnt75  thanks for reply, can you share some resource how you are asking to do as i'm bit new

[johnt75]

Have a look at https://www.sqlbi.com/blog/marco/2020/07/15/creating-calculation-groups-in-power-bi-desktop/