Result of multiple select in slicer should match all selected values

[Anonymous]

Hi all, 

I would like to add a slicer with the possibility to select multiple values... the result should match all selected values (see examples below).

I have been looking for a solution for this problem for a while, can someone help me?

[v-xicai · Accepted solution]

Hi @Anonymous ,

You can create measures using DAX below, and then put measure 2 in Visual level filter of table visual displaying the [Custom number],setting value of measure 2 is 1.

Measure 1 = CALCULATE(CONCATENATEX(VALUES(Table1[Custom number]),[Custom number],,MAX([Custom number]),ASC),FILTER(ALLSELECTED(Table1),Table1[Profile]=SELECTEDVALUE(Table1[Profile])&&Table1[Custom number]<=MAX(Table1[Custom number])))

Measure 2 = IF(CALCULATE(COUNTAX(Table1,[Measure 1]),ALLSELECTED(Table1[Profile]))=CALCULATE(DISTINCTCOUNT(Table1[Profile]),ALLSELECTED(Table1)),1,2)

Here is my test pbix: https://qiuyunus-my.sharepoint.com/:u:/g/personal/pbipro_qiuyunus_onmicrosoft_com/EWvKiHnafBBJrnWK8jh1bmoB_77rR_LQNusktqKx7RCYQA?e=xzaa2d

Best Regards,

Amy

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

[Anonymous]

Perfect solution.... Thanks!!!!