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] )
Was this helpful?
Let us know your thoughts...