SUMMARIZE

Syntax

SUMMARIZE(<table>, <groupBy_columnName>[, <groupBy_columnName>]…[, <name>, <expression>]…)

Tutorial with example

Learn how to use the function SUMMARIZE in DAX/ Powerpivot.

The function SUMMARIZE can return a summary of sales grouped around the calendar year and the product category name, this result table allows you to do analysis over the re-seller sales by year and product category.

Northwind data source: https://www.youtube.com/watch?v=k3NMI…
Icons: https://www.iconfinder.com/

Download example file:

Link to Power BI file here.

Remarks

1. Each column for which you define a name must have a corresponding expression; otherwise, an error is returned. The first argument, name, defines the name of the column in the results. The second argument, expression, defines the calculation performed to obtain the value for each row in that column.
2. groupBy_columnName must be either in table or in a related table to table.
3. Each name must be enclosed in double quotation marks.
4. The function groups a selected set of rows into a set of summary rows by the values of one or more groupBy_columnName columns. One row is returned for each group.