multi selections in slicer display blank in visuals

[Anonymous]

Hi I have a slicer with example values A,B,C,D and 4 single cards. 

when I select A in the slicer the card for A display value but when i have multi selections all display blanks 

my DAX is like this:

SWITCH(TRUE(),

SELECTEDVALUE(Slicer) IN {"A"},Sum(total)).
Thanks for all support.

[v-tangjie-msft · Accepted solution]

Hi @Anonymous ,

You can update the measure.

Measure = SWITCH(
    TRUE(),
    HASONEVALUE('Table'[slicer]),
    IF(
        SELECTEDVALUE('Table'[slicer]) IN {"A"},
        SUM('Table'[value])
    ),
   SUM('Table'[value])
)

 Then the result is as follows.

If the above one can't help you get the desired result, please provide some sample data in your tables (exclude sensitive data) with Text format and your expected result with backend logic and special examples. It is better if you can share a simplified pbix file. Thank you.

Best Regards,

Neeko Tang

If this post  helps, then please consider Accept it as the solution  to help the other members find it more quickly.