DAX function

SUMMARIZECOLUMNS — DAX function reference

Group and summarize (modern, faster).

Syntax

dax

SUMMARIZECOLUMNS(<groupBy_column1> [, …], [<filterTable1>] [, …], "<name1>", <expression1> [, …])

dax

SUMMARIZECOLUMNS(Region[Name], "Sales", SUM(Sales[Amount]))

→ A grouped table

dax

SUMMARIZECOLUMNS(
    Product[Category], 'Date'[Year],
    FILTER(ALL(Sales[Channel]), Sales[Channel] = "Online"),
    "Sales", SUM(Sales[Amount])
)

→ Category/Year sales for the Online channel only

dax

SUMMARIZECOLUMNS(
    Product[Category],
    "Sales", SUM(Sales[Amount]),
    "Margin %", DIVIDE(SUM(Sales[Profit]), SUM(Sales[Amount]))
)

→ Multiple measures grouped by Category — the shape a matrix visual generates under the hood

SUMMARIZECOLUMNS is what Power BI visuals generate behind the scenes: it applies star-schema-aware filter propagation and omits grouping combinations that produce no rows — but that also means it can't be used inside a calculated column, only in measures or DAX queries.
Filter table arguments passed positionally must be table expressions (e.g., FILTER(ALL(...), …) or TREATAS), not simple boolean expressions like the filter arguments in CALCULATE.

From Iterators & variables