Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I'm having trouble figuring out how to get two slicers to use "and" filtering on a matrix.
All of the data is in one table, with employee name, a category, and a number value. Looks sort of like this:
I want to be able to filter for employees who have only 3s (or 3s and 2s) in all of the categories selected in the other slicer. But it is listing employees with a 3 in any category along with blanks. The dashboard looks like this currently:
But we were hoping to get somehting like this:
Any Ideas would be appreciated, thanks.
Solved! Go to Solution.
In this scenario, you can create a measure to determine if Cats related to current Name is equal to selected Cats.
Measure = IF ( CALCULATE ( DISTINCTCOUNT ( Table1[Cat] ), ALLSELECTED ( Table1[Cat] ) ) = CALCULATE ( DISTINCTCOUNT ( Table1[Cat] ), ALL ( Table1[Name] ), ALLSELECTED ( Table1[Cat] ) ), 1, 0 )
Then add above measure into Visual Level Filter.
Regards,
In this scenario, you can create a measure to determine if Cats related to current Name is equal to selected Cats.
Measure = IF ( CALCULATE ( DISTINCTCOUNT ( Table1[Cat] ), ALLSELECTED ( Table1[Cat] ) ) = CALCULATE ( DISTINCTCOUNT ( Table1[Cat] ), ALL ( Table1[Name] ), ALLSELECTED ( Table1[Cat] ) ), 1, 0 )
Then add above measure into Visual Level Filter.
Regards,
Thanks, that worked like a charm.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
100 | |
80 | |
63 | |
58 |
User | Count |
---|---|
148 | |
111 | |
94 | |
84 | |
67 |