topic Re: Multiple Slicer selection in DAX Commands and Tips

Multiple Slicer selection

meena16_vibrant — Sun, 09 Oct 2022 08:02:31 GMT

Slicer

AAA

BBB

When I select Slicer AAA, calculation = total value * 10%

When I select slicer BBB, calculation =total value * 0%

Suppose total value =100

Table I should get as below. It might be single selection or multi selection. How do I achieve this in measure?

AAA	1
BBB	0

Measure =

SWITCH(TRUE(),

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

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

I tried above measures but it retrieves 1 for both.(Multi selection)

AAA	1
BBB	1

Is there a way to achieve this scenario in measure? Any suggestions will be of great help.

Greg_Deckler — Sun, 09 Oct 2022 08:28:24 GMT

Measure = SWITCH(TRUE(), "AAA" IN DISTINCT(Table[coln]),total value * 0.01, "BBB" IN DISTINCT(Table[coln]),total value * 0)

meena16_vibrant — Sun, 09 Oct 2022 12:25:23 GMT

Thanks for the response. It worked.

RAJRANJITHBROS — Thu, 20 Oct 2022 10:19:54 GMT

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