topic Re: How to select multiple values from a slicer and show it in visuals using DAX FUNCTIONS? in DAX Commands and Tips

How to select multiple values from a slicer and show it in visuals using DAX FUNCTIONS?

soumyakantibhar — Thu, 21 Apr 2022 14:25:36 GMT

Hi,

I have written this code for

calculating total sales.

Total Sales =

VAR CountryMultiple = [SelectedValue]

RETURN

CALCULATE( SUM(Table1[Sales]),

FILTER( Table1, Table1[Country ] in

{SELECTEDVALUE('Selection 1'[Country ]), CountryMultiple}))

and for "Selected Value" I have written this code

SelectedValue = CONCATENATEX(ALLSELECTED ('Selection 2'[Country ]),'Selection 2'[Country ],", ")

First value should be from main country slicer and 2nd and so on will be from country slicer

How to select multiple values from

2nd slicer and show them in visuals?

Thank You

Re: How to select multiple values from a slicer and show it in visuals using DAX FUNCTIONS?

amitchandak — Thu, 21 Apr 2022 15:12:11 GMT

soumyakantibhar , try measure like

CALCULATE( SUM(Table1[Sales]),
FILTER( Table1, Table1[Country ] in allselected('Selection 1'[Country ])) )

Re: How to select multiple values from a slicer and show it in visuals using DAX FUNCTIONS?

soumyakantibhar — Thu, 21 Apr 2022 16:34:55 GMT

Thank You for your reply.

Actually I have to show single country for selection1[Country] from main country slicer as first row of the table and secondly show multiple selection values from selection2[Country] in country slicer as second and third row of the table.

Re: How to select multiple values from a slicer and show it in visuals using DAX FUNCTIONS?

tamerj1 — Thu, 21 Apr 2022 20:28:12 GMT

Hi soumyakantibhar

you may try

SelectedValue = SELECTEDVALUE ( 'Selection 1'[Country ] ) & UNICHAR ( 10 ) & CONCATENATEX ( ALLSELECTED ( 'Selection 2'[Country ] ), 'Selection 2'[Country ], UNICHAR ( 10 ) )

Re: How to select multiple values from a slicer and show it in visuals using DAX FUNCTIONS?

Anonymous — Wed, 27 Apr 2022 08:36:30 GMT

Hi soumyakantibhar ,

Please refer this formula.

Measure = IF(SELECTEDVALUE(Table1[country]) = SELECTEDVALUE(selection1[country])||SELECTEDVALUE(Table1[country]) in VALUES(selection2[country]),SUM(Table1[sales]),BLANK())

Best Regards,

Jay