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.
Hi,
I have a page with multiple calculated measures that I would like to filter using both regular slicers (working well) and a set of yes/no slicers that need the OR condition rather than AND condition.
Slicers typically work with AND conditions but for one particular set of slicers I need the condition to be OR
I've tried a bunch of things - the closest I got was this:
Hi! Slicers always work with "and" unless you override the filter context within your measures.
Depending on the number of slicers you have, this could become quite ugly because you would have to check for which slicers are filtered and filter appropriately. But there might be an easier way...try something like this:
CALCULATE(
[Units],
Brands,
Occupations,
{Any other slicers one at a time separated by commas}
)
Hope this helps! 🙂
Thank you for your help!
I tried the following but it says "The True/False expression does not specify a column"
VAR Brand1=ISFILTERED(DATA[Q3_1])
VAR Brand2=ISFILTERED(DATA[Q3_2])
RETURN
CALCULATE(COUNT(DATA[Q1]),Brand1,Brand2)
Hi @Anonymous . Each variable should be IF ( ISFILTERED(), true condition, false condition)
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 |
---|---|
106 | |
94 | |
76 | |
62 | |
50 |
User | Count |
---|---|
147 | |
106 | |
104 | |
87 | |
61 |