Cheat Sheets/Power BI/SUMMARIZE
DAX function

SUMMARIZEDAX function reference

Group rows and summarize.

Syntax

dax
SUMMARIZE(<table>, <groupBy_column1> [, <groupBy_column2>, …] [, <name>, <expression>, …])

Examples

dax
SUMMARIZE(Sales, Region[Name], "Sales", SUM(Sales[Amount]))
A grouped table

Using SUMMARIZE purely for grouping, with no aggregation columns, is the safe, well-supported use case.

dax
SUMMARIZE(Sales, 'Date'[Year], 'Date'[Quarter])
Distinct Year/Quarter combinations present in Sales
dax
ADDCOLUMNS(SUMMARIZE(Sales, Product[Category]), "Sales", CALCULATE(SUM(Sales[Amount])))
The recommended pattern: group with SUMMARIZE, aggregate with ADDCOLUMNS

Common mistakes & gotchas

Related DAX functions

From Iterators & variables

← Back to the Power BI (DAX) cheat sheet