summarize dax | How to use summarize in DAX | Power bi Dax Tutorial
Vložit
- čas přidán 10. 07. 2024
- 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:
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 par...
2.How to Calculate Running Totals: • How to calculate runni...
3.Duplicate Vs Reference : • power bi difference be...
4.Merge Vs Append: • power bi difference be...
5.Calculate Function in DAX Power BI: • What is Calculate Func...
6.Filter Function in Power BI: • Filter Function in Pow...
7.Row Vs Filter Context: • Row Context Vs Filter ...
8.ALL DAX Function: • How to use ALL Dax Fun...
9.ALL Vs ALLSELECTED : • allselected dax|all vs...
10.ALL Vs ALLSELECTED VS ALLEXCEPT : • All Vs AllSelected Vs ...
11.ALL Vs REMOVEFILTERS : • ALL Vs REMOVEFILTERS D...
12.TOPN Dax Usage : • TOPN Dax | How to use ...
Learn Power BI through our vlog and Free Videos:
powerbizone.com/category/arti...
You can download the pbix file for your self practice sessions from :
drive.google.com/file/d/1OmBr...
Do not forget to Like ,Subscribe and comment which keeps me motivated !
Your explanation is specific and in detailed and cover all th points.
Thank you bro .It is comments like this that keeps me going !
Thank you so much. Very clear expressions.
Glad you liked it !
Really nice. Need to see it again.
nice to see you back :)
Perfect sir ...👍👍👍
So nice of you. Do subscribe and Keep watching for more !
You can download the pbix file for your self practice sessions from :
drive.google.com/file/d/1OmBr8hTDxERT-1HYU0U0peOWKp5NOAJG/view?usp=sharing
Do not forget to Like ,Subscribe and comment which keeps me motivated !
Excellent video! It solved a confusion that i had for a long time!
Thank you for the comment bro .Glad you liked it!