SUMMARIZE DAX Function in Power BI

The SUMMARIZE dax function returns a summary table for the requested totals over a set of groups.

DAX Syntax SUMMARIZE (table, groupBy_columnName[, groupBy_columnName]…[, name, expression]…)

Example: Let’s create a table in Power BI.

DAX

Summarize Table = 
SUMMARIZE (
    Sheet1,
    Sheet1[Country],
    "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:

Previous Next