SUMMARIZECOLUMNS

Syntax

Returns a summary table over a set of groups.

SUMMARIZECOLUMNS( <groupBy_columnName> [, < groupBy_columnName >]…, [<filterTable>]…[, <name>, <expression>]…)

In todays video I will show you how to use the DAX function SUMMARIZECOLUMNS.

Download example files:

Download the pbix here.

Remarks

SUMMARIZECOLUMNS does not guarantee any sort order for the results.

A column cannot be specified more than once in the groupBy_columnName parameter. For example, the following formulas are invalid.

SUMMARIZECOLUMNS( Sales[StoreId], Sales[StoreId] )