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:
