summarize dax | How to use summarize in DAX | Power bi Dax Tutorial

Todays DAX Tutorial we talk about SUMMARIZE Dax Function in Power BI.
Usage of Summarize Dax :
1.Grouping :Getting out unique values from a Column
2.Aggregating data with multiple Columns
3.Using Summarize inside a measure

Syntax of SUMMARIZE Dax : SUMMARIZE (table, groupBy_columnName[, groupBy_columnName]…[, name, expression]…)

Parameters Used:

Term Definition
table Any DAX expression that returns a table
groupBy_ColumnName (Optional) The name of an existing column used to create summary groups based on the values found in it. This parameter cannot be an expression.
name The name given to a total /summarize column
expression Any DAX expression that returns a single scalar value, where the expression is to be evaluated multiple times (for each row/context).
SUMMARIZE Dax Parameter Explained
Summarize can be used in the following ways :

1.Return distinct list of values as shown in the below code:

Distinct Countries =
SUMMARIZE(financials,
financials[Country]
)
2.Return a summary table containing aggregated values as shown below:

Sales/Profit per Country per Yr =
SUMMARIZE(financials,
financials[Country],
financials[Year],
"Sales",sum(financials[ Sales]),
"Profit",sum(financials[Profit]))
3.We can use summarize inside a measure as shown below.

Measure-MAX_Sales/Profit per Country per Yr =

Var a1=
SUMMARIZE(
financials,
financials[Country],
financials[Year],
"Sales3",MAX(financials[ Sales])
)


var b=sumx(a1,[Sales3])
return b

For more detailed usage of Summarize Dax function in Power BI refer below:

#powerbi #powerbitraining #powerbidax #powerbi_training #daxfunctions #powerbizone

Chapters:
0:14 :Introduction to Summarize DAX in Power BI
0:44 Syntax of Summarize Dax
1:45 Example /Usage 1 of Summarize Dax
2:38 Example /Usage 2 of Summarize Dax
3:48 Example /Usage 3 of Summarize Dax (Using Measure)

Check out other Power BI Tutorials Videos :

Learn Power BI through our vlog and Free Videos:

You can download the pbix file for your self practice sessions from :
Do not forget to Like ,Subscribe and comment which keeps me motivated !

[ashokreddy]

Your explanation is specific and in detailed and cover all th points.

[powerbizone]

You can download the pbix file for your self practice sessions from :
Do not forget to Like, Subscribe and comment which keeps me motivated !

[dcpowered]

Excellent video! It solved a confusion that i had for a long time!

[veebee]

Thank you so much. Very clear expressions.