How to i select multiple items in slicer

[mithiladas02]

Hi,

i am using the below dax for slicer. But i am not able to select multiple items at a time. It is showing only 1 like A or B or C. how can i select A,B,C at a time. In formating i select miltiple selection also but didnt work. 

2,"A", [Measure 1],

3,"B", [Measure 2],

4,"C", [Measure 3],

5, "D", [Measure 4],

1, "None"

[Anonymous · Accepted solution]

Hi @mithiladas02 ,

You could use selectedmeasurename() function.

Create a slicer table contains the measure names you are using and add the below part of formula to the measures.

IF(SELECTEDMEASURENAME() in VALUES(slicer[slicer]).

For example:

_avg = IF(SELECTEDMEASURENAME() in VALUES(slicer[slicer]), AVERAGE('Table'[value]))

_max = IF(SELECTEDMEASURENAME() in VALUES(slicer[slicer]), MAX('Table'[value]))

_min = IF(SELECTEDMEASURENAME() in VALUES(slicer[slicer]), MIN('Table'[value]))

_sum = IF(SELECTEDMEASURENAME() in VALUES(slicer[slicer]), SUM('Table'[value]))

Best Regards,

Jay

[Nathaniel_C]

Hi @mithiladas02 ,
You don't give us enough information to solve this, but have you tried CTRL key along with your choices?

Let me know if you have any questions.

If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos 👍are nice too.
Nathaniel

[mithiladas02]

Yes i tried. i made a dynamic line chart where i have created measure for slicer. on this measure i am not able to select multiple item to show the compare in line chart.