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:
https://powerbizone.com/summarize-dax...

#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 :
1.SamePeriodLastYear with Example:    • difference between parallelperiod and same...  
2.How to Calculate Running Totals:    • How to calculate running total in power bi  
3.Duplicate Vs Reference :    • power bi difference between duplicate and ...  
4.Merge Vs Append:    • power bi difference between merge and append  
5.Calculate Function in DAX Power BI:    • What is Calculate Function in Power BI DAX...  
6.Filter Function in Power BI:    • Filter Function in Power BI DAX  
7.Row Vs Filter Context:    • Row Context Vs Filter Context in Power BI  
8.ALL DAX Function:    • How to use ALL Dax Function in Power BI | ...  
9.ALL Vs ALLSELECTED :    • allselected dax|all vs allselected dax | p...  
10.ALL Vs ALLSELECTED VS ALLEXCEPT :    • All Vs AllSelected Vs AllExcept | Power BI...  
11.ALL Vs REMOVEFILTERS :    • ALL Vs REMOVEFILTERS Difference in Power B...  
12.TOPN Dax Usage :    • TOPN Dax | How to use topn dax in power bi...  

Learn Power BI through our vlog and Free Videos:
https://powerbizone.com/category/arti...

You can download the pbix file for your self practice sessions from :
https://drive.google.com/file/d/1OmBr...
Do not forget to Like ,Subscribe and comment which keeps me motivated !