Forum Discussion
Select a measure based on filter page selection
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 selec...
Hi Anonymous ,
You can use this measure.
Selected Value =var __ValueClicked = SELECTEDVALUE(Table2[Type])returnSwitch(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
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
Hi harshnathani,
Thank a lot.
The DAX Code is great 😉
Anonymous ,
Thank You 🙂
Regards,
Harsh Nathani