Forum Discussion
Switch Formula on Multiple Selection on Slicer?
Hi All, I have a what I think, a pretty simple model/ask I am asking of Power BI (I think), and still can't figure out what I'm doing wrong. I have one fact table and a product line (catego...
You could try using SELECTEDVALUE().
Var A=....
Var B=...
Return SWITCH(SELECTEDVALUE(Selection_lowest),
"A", A,
"B", B,
A+B)
If you choose distinct filter choices, you get the respective measures back. But once you choose more than one filter, you will get the alternate result (in this case A+B). https://learn.microsoft.com/en-us/dax/best-practices/dax-selectedvalue