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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
rdg515
Resolver I
Resolver I

How to maintain Query folding with multiple filters using an OR operator

I want to filter the table results by checking if Column A > 0 or Column B > 0.  At this filter step, query folding breaks; I am using the right-click > View Native Query being grayed out as my indication.

 

If I just filter on Column A > 0 then query folding is working if I just did Column B > 0 it's also working, and if I did Column A > 0 AND Column B > 0 it works.

 

The issue seems to be with the OR condition.  I even tried adding a custom column true / false column using an if statement with the OR conditions but query folding broke on that step.

1 ACCEPTED SOLUTION
rdg515
Resolver I
Resolver I

Disregard, I'm an idiot, I removed Column B in a previous step Power Query didn't throw any warnings so I didn't realize that was happening until I applied.  OR condition works just fine.

View solution in original post

1 REPLY 1
rdg515
Resolver I
Resolver I

Disregard, I'm an idiot, I removed Column B in a previous step Power Query didn't throw any warnings so I didn't realize that was happening until I applied.  OR condition works just fine.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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