Press "Enter" to skip to content

Filter Behaviors: SUMMARIZECOLUMNS and CALCULATETABLE

Marco Russo explains a difference:

We recently updated SUMMARIZECOLUMNS on DAX Guide by adding an example that clarifies the difference between a filter applied to SUMMARIZECOLUMNS and a filter applied to CALCULATETABLE.

Read on for an example of how summarizecolumns() normally works but how things might change a little bit when you introduce calculatetable() to the mix.