Saturday, February 9, 2019

How to create a Summary Table by using SUMMARIZE Function in Power BI DAX

How to use the SUMMARIZE Function to Summarize data Group By specific Columns in Power BI DAX
The SUMMARIZE Function in Power BI DAX is used to create a Summary Table from the Fact Table, and data will be Grouped by the specific columns from the related Dimension Tables or from the same Fact Table.
Scenario :
Suppose we have our Power BI Data Model as follows..

Now from the above Data Model, we can have a Tabular Report with Sales details as below 
Note :
In the above table, the Measure [NetSales] is calculated using the below DAX Expression.
TotalSales = SUMX(FactSales,FactSales[Units_Sold]*RELATED(DimProducts[Unit_Price]))


Now from the above Sales details table, we can prepare a Sales Summary table, with data Group By columns MonthN, Region_Name, using the below DAX Expression :

SalesSummary = 
SUMMARIZE(FactSales, DimRegion[Region_Name], FactSales[MonthN],
"SumSales"SUMX(FactSales,FactSales[TotalSales]),
"SumUnits",  SUM(FactSales[Units_Sold]))

Note :
Since the measure [TotalSales] is not a Direct Measure of FactTable, I have used the SUMX Function instead of SUM Function.

Result :


-------------------------------------------------------------------------------------------------------- 
Thanks, TAMATAM ; Business Intelligence & Analytics Professional 
--------------------------------------------------------------------------------------------------------

No comments:

Post a Comment

Hi User, Thank You for visiting My Blog. Please post your genuine Feedback or comments only related to this Blog Posts. Please do not post any Spam comments or Advertising kind of comments which will be Ignored.

Featured Post from this Blog

How to compare Current Snapshot Data with Previous Snapshot in Power BI

How to Dynamically compare two Snapshots Data in Power BI Scenario: Suppose, we have a sample Sales data, which is stored with Monthly Snaps...

Popular Posts from this Blog