Power BI Dax Formula

[hawkeyes12]

Hello,

I am trying to create a Measure in Power BI that will execute a measure only if "Select all" is chosen in a Slicer. Any ideas on how to incorporate this?

Here are some additional details on my data:

1. I have 4 tables: Calendar, States, State Tests and County Tests

2. I have a line chart visual showing the number of tests for each day (this is a measure)

3. I have two slicers to enable filtering; 1 for States and 1 for Counties

4. If I choose "Select all" in the county filter, I want the bar charts to show. But if I choose a specific county or multiple counties, I do not want the bar charts to show. 

[mahoneypat · Accepted solution]

You could use this approach:

Conditional Measure = IF(ISFILTERED(Table[County]), BLANK(), [Your Measure])

If this works for you, please mark it as the solution.  Kudos are appreciated too.  Please let me know if not.

Regards,

Pat

[hawkeyes12]

This worked!! thanks so much @mahoneypat !

[lbendlin]

You will want to use FILTERS() and COUNTROWS() to identify that situation. Caution: You may  need to cover two separate scenarios. When no items are selected, and when all items are selected.

https://docs.microsoft.com/en-us/dax/filters-function-dax

EDIT:  Never mind, both scenarios return the same number (count of all slicer items)