selectedvalue/allselected for multiple values

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,

Anonymous Anonymous 

The reason why your measure is only able to select one value is that it uses the ALLSELECTED function, which returns a single value when multiple items are selected in the slicer.

To allow for multiple values to be selected in the slicer, you can modify your measure to use the VALUES function instead of ALLSELECTED. Here's an updated version of your measure:

Q3 TEST3 = CALCULATE( COUNTROWS('Q3'), FILTER( ALLEXCEPT(Q3, Q3[Gender], Q3[Age], Q3[Employment], Q3[Tenure]), Q3[Facility Name] IN VALUES(Demographics[Facility Name]) ) )

This modified measure uses the IN operator and the VALUES function to filter the data based on the selected values in the Demographics[Facility Name] slicer. The VALUES function returns a table of the selected values in the slicer, which can include multiple values.

Once you have updated your measure, you can use it in a bar chart visual along with the Demographics[Facility Name] field in the Axis section to create the bar chart you desire.