Forum Discussion

mshparber's avatar
mshparber
Icon for Advocate I rankAdvocate I
4 years ago
Solved

ALLEXCEPT entire table

I am trying to build a measure that removes filters from any table, except for Calendar. I try to do:

= CALCULATE([Sales Amt], ALLEXCEPT(Calendar)

but it requires specific columns. 
Maybe this should work?

=CALCULATE([Sales Amt], ALL(), VALUES(Calendar))

or does VALUES also require columns?

Need Help
  • CNENFRNL's avatar
    CNENFRNL
    4 years ago

    In CALCULATE(), tables can be used as filter modifiers; thus you can author DAX formula this way,

    = CALCULATE([Sales Amt], ALL(), Calendar)