Forum Discussion
selectedvalue/allselected for multiple values
I created this measure and slice by a slicer: Q3 TEST3 = CALCULATE(COUNTROWS ('Q3'), FILTER(ALLEXCEPT(Q3,Q3[Gender],Q3[Age],Q3[Employment],Q3[Tenure]),Q3[Facility Name]=ALLSELECTED(Demographics[Fac...
Hello,
The issue here is tthat it is using the ALLSELECTED function which returns a single value for the selected item in the slicer. If you select multiple items in the slicer, it will return an error because the ALLSELECTED function cannot return multiple values.
To solve this issue, you can use the VALUES function instead of ALLSELECTED function in your measure.
Thanks,
The VALUES function works. Another further problem is that i would like to use it for multiple slicer. I have tried to use
VALUES(Demographics[Facility Name] ||
VALUES(Demographics[Gender]
But it seems not work