Skip to main content
Showing results for 
Search instead for 
Did you mean: 

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.

Post Prodigy
Post Prodigy

Or statement in FILTER not overriding exisitng filter context?



I've uploaded my pbix file here -> . I have the following data:


backend table.JPG


And two calculated measures:

answer c.JPGanswer d.JPG


Which I've displayed in the visuation table below:

output table.JPG


What I don't understand is that for answer c the below line of code is not overriding the existing filter context? i.e. why is every line of the above table visualisation not 5 for the answer d column? I thought the FILTER function leaves the existing filter context intact but then overrides any filter context where a filter is defined within the FILTER function?

Product[Color] = "Red" || Product[Brand] = "SQLBI"
Thanks for your help,
Post Prodigy
Post Prodigy



I believe this is to the behavior of ALL. I've found ALLEXCEPT to supply a solution for most of these situations. It will remove implicit and explicit filters, with exception those applied ot the columns secified in the expression.


You can also try creating a custom table to see the result of your filter. 

filter ( filter ( your filter in the calculate ) , the implicit filters of the visual )

Helpful resources

Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City


Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.