DAX Function Guide

This function will summarize the huge amount of rows of data into one table with provided criteria column. For example, you may have multiple city sales values but each city has multiple rows of transactions, so using SUMMARIZE function we can create a summary table where each city will have an only one-row transaction with the summarized line.

The SUMMARIZE function is best use to perform only the grouping of values, avoiding its use to compute additional columns.

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.