Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
Solved! Go to 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
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
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
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
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)
User | Count |
---|---|
51 | |
27 | |
19 | |
18 | |
14 |
User | Count |
---|---|
91 | |
86 | |
39 | |
23 | |
22 |