Forum Discussion
Power BI Dax Formula
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.
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
3 Replies
- mahoneypat
Microsoft Employee
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
This worked!! thanks so much mahoneypat !
- lbendlin
Super User
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)
