Forum Discussion

Anonymous

Not applicable

6 years ago

Solved

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 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

DAX Calculation

DAX filter formula

Anonymous
6 years ago
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

3 Replies

Anonymous
Not applicable
6 years ago
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
  Not applicable
  6 years ago
  Hi harshnathani,
  
  Thank a lot.
  
  The DAX Code is great 😉
  - Anonymous
    Not applicable
    6 years ago
    Anonymous ,
    
    Thank You 🙂
    
    Regards,
    Harsh Nathani

Related content