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.