Forum Discussion

DouweMeer's avatar
DouweMeer
Impactful Individual
1 year ago

Faster method for double boolean on filter?

Got this requirement that a source file contains per postal code a categorization. However, sometimes for a particular label, all postal codes are allowed. So I created something like this:   minx...
Tips and Tricks
bhanu_gautam's avatar
bhanu_gautam
Super User
1 year ago

DouweMeer Try using

MINX(
FILTER(
'source file',
'source file'[country] = 'fact'[country] &&
('source file'[postal code] = "all" || 'source file'[postal code] = 'fact'[postal])
),
'source file'[value]
)

 

This approach uses a logical OR (||) to check if the postal code is "all" or matches the postal code in the fact table, which should be more efficient than using an IF statement inside the filter.

DouweMeer's avatar
DouweMeer
Impactful Individual
1 year ago

My postal check isn't as easy as I made it seem. It is like: 

 

left ( 'fact'[postal] , len ( 'source'[postal] ) ) = 'source'[postal]

 

Was thinking of not having it verify the postal when the source file's info is all. 

 

Whilst writing this, I came up with another question:

https://community.fabric.microsoft.com/t5/Desktop/Order-in-which-filter-works/m-p/4405425#M1371776

Would you know that question's answer?

 

Is it faster to check on both at the same time instead of my prior of if ( equal all , true , otherwise ) ?