SUMMARIZECOLUMNS DAX Function in Power BI
The SUMMARIZECOLUMNS DAX function returns a summary table over a set of groups.
DAX Syntax
SUMMARIZECOLUMNS(groupBy_columnName [, groupBy_columnName]…, [filterTable]…[, name, expression]…)
Example: Let’s create a table in Power BI.
DAX
SUMMARIZECOLUMNS Table =
SUMMARIZECOLUMNS(
Sheet1[Country],
FILTER(Sheet1, Sheet1[10th Marks] >300),
"Total 10th Marks by country", SUM ( Sheet1[10th Marks] ),
"Total 12th Marks by country", SUM ( Sheet1[12th Marks] )
) The output of the above dax function is shown below:
