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 ) ?