Select a measure based on filter page selection

[Anonymous]

Hi community,

I would know if exist the method to select a dinamically measure with link on filter page.

At below an example:

I have a one filter page e.g "brand company" and how to select the modality, the KPIs switch in dyanamically mode. The widget is a Card

I think this type of approach but it doesn't work:

Measure_Final = IF ((FILTER_1) = "A"; Measure_1; IF(FILTER_1) = "B"; Measure_2; IF(FILTER_1) = "C"; Measure_3; "Measure_Overall")

For more details i have upload a screenshot

Thanks advance for your support,

Best regard

[harshnathani · Accepted solution]

Hi @Anonymous ,

You can use this measure.

Selected Value =

var __ValueClicked = SELECTEDVALUE(Table2[Type])

return

Switch(

true(),

__ValueClicked = "A", "Try Measure A",

__ValueClicked = "B" , "Try Measure B",

__ValueClicked = "C" , "Try Measure C",

__ValueClicked = "D", "Try Measure D",

"Nothing is filtered"

)

Replace your measures with "Try Measure A","Try Measure B", respectively and it should work.

Did I answer your question? Mark my post as a solution!

Regards,

Harsh Nathani

[Anonymous]

Hi harshnathani,

Thank a lot.

The DAX Code is great 😉

[harshnathani]

@Anonymous ,

Thank You 🙂

Regards,

Harsh Nathani