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:

SUMMARIZECOLUMNS DAX Function in Power BI