Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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"
Solved! Go to 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
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
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
Proud to be a Super User!
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.
User | Count |
---|---|
128 | |
109 | |
100 | |
65 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |