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

[soumyakantibhar]

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

[Anonymous · Accepted solution]

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

[tamerj1]

Hi @soumyakantibhar 

you may try

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

[amitchandak]

@soumyakantibhar , try measure like

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

[soumyakantibhar]

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.