selectedvalue/allselected for multiple values

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.