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