Forum Discussion

Frequent Visitor

3 years ago

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

3 years ago

Measure =

SWITCH(TRUE(),

"AAA" IN DISTINCT(Table[coln]),total value * 0.01,

"BBB" IN DISTINCT(Table[coln]),total value * 0)

Community Champion

3 years ago

Measure =

SWITCH(TRUE(),

"AAA" IN DISTINCT(Table[coln]),total value * 0.01,

"BBB" IN DISTINCT(Table[coln]),total value * 0)

Frequent Visitor

3 years ago

Hi,

I need your help,

I have a situation here where I need to show multiple values selected from multiple sicers in a card visual.

multiple values of same slicer should be seperated by ","and multiple values from multiple slicers should be seperated by "|".

when no values selected from any of the slicers , it should show "Not Selected"

for example, if I select 2017 and 2018 from Year slicer,

result is : 2017,2018 (here "|" is not expecting after the result)

if I select HYD and BZA from LocID slicer and 2021,2022 from year slicer and Azure-C,Azure-F from CourseID,

result is: HYD,BZA | 2021,2022 |Azure-C,Azure-F

If I select no values from three slicers,

Result is: Not Selected

Thanks in advance...