Check if nothing is selected in a matrix

Hi benjos23, I'll be honest, saying I've been lost a bit in your case description... However, focusing on a final question:

"Is there a way to specifically check if many values of a certain column are being selected in the matrix?"

The answer is Yes.

• You can use ISFILTERED – DAX Guide in case you want to check if any "direct" filter is applied on a column.
• In case you are interested in indirect filter (i.e., a filter is applied to any column of the same table or in a related table), take a look at ISCROSSFILTERED – DAX Guide
• Consider that you won't be able to distinguish "Select All" from "Nothing is selected" as the result query would be the same

Once you use one of these 2 functions, you can combine them with SELECTEDVALUE(), which will return a result only if a single value is selected. So: if column is filtered (directly or indirectly) and SELECTEDVALUE = BLANK() (i.e., more than one vale is selected), you can define the desired behavior.

Good luck with your project! 🙂