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
Fowmy's avatar
Fowmy
Super User
1 year ago

DouweMeer 

M =
VAR __FactCountry = 'fact'[country]
VAR __FactPostal = 'fact'[postal]
VAR _FilteredTable =
    FILTER (
        SUMMARIZE (
            'source file',
            'source file'[country],
            'source file'[postal code],
            'source file'[value]
        ),
        'source file'[country] = __FactCountry
            && ( 'source file'[postal code] = "all"
            || 'source file'[postal] = __FactPostal )
    )
RETURN
    MINX ( _FilteredTable, 'source file'[value] )
  • DouweMeer's avatar
    DouweMeer
    Impactful Individual
    1 year ago

    Why do you work with VAR's in this scenario? Aren't VAR's stored in memory during operation? Wouldn't that suck in capacity? 

    • Fowmy's avatar
      Fowmy
      Super User
      1 year ago

      DouweMeer 

      When you use a variable, you avoid calling the field within filter on each interation, this way, you should see the code that I shared should show better performance. 

      Did you try the measure?