Skip to main content
cancel
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.

Reply
CloudMonkey
Post Prodigy
Post Prodigy

Or statement in FILTER not overriding exisitng filter context?

Hi,

 

I've uploaded my pbix file here -> https://ufile.io/dsp0vngv . 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,
 
CM
1 REPLY 1
DouweMeer
Post Prodigy
Post Prodigy

@CloudMonkey 

 

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

Announcements
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

PBI_APRIL_CAROUSEL1

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.