Forum Discussion
Solved
Multiple Slicer selection
Slicer AAA BBB When I select Slicer AAA, calculation = total value * 10% When I select slicer BBB, calculation =total value * 0% Suppose total...
meena16_vibrant Try:
Measure = SWITCH(TRUE(), "AAA" IN DISTINCT(Table[coln]),total value * 0.01, "BBB" IN DISTINCT(Table[coln]),total value * 0)
meena16_vibrant Try:
Measure =
SWITCH(TRUE(),
"AAA" IN DISTINCT(Table[coln]),total value * 0.01,
"BBB" IN DISTINCT(Table[coln]),total value * 0)
Thanks for the response. It worked.