DAX-SUMMARIZE (ROLLUP)

  The following example adds roll-up rows to the Group-By columns of the SUMMARIZE function call. EVALUATE SUMMARIZE( ‘Internet Sales’, ROLLUP (‘Date'[Calendar Year],Product[Product Category Name]), "Sales", ([Internet Total Sales]), "Tax",([Internet Total Tax Amount])) Red Box shows the sub-total of Categories further Brown Box shows Total of all Categories across all years.

1

DAX – SUMMARIZE Statement

SUMMARIZE function returns a summary table for the requested totals over a set of groups. Readers familiar with T-SQL SELECT statement, this is the equivalent of writing a query using the GROUP BY clause. Syntax – SUMMARIZE(<table>, <groupBy_columnName>[, <name>, <expression>]…) Demo – The Following example returns summary of the Internet Sales grouped around Country, Category…

0

It takes 4 Clicks to Build a Model (Cube) in Denali Tabular Mode

Click 1 – Create a Tabular Project Click 2 – Import Tables (Master / Facts) from DW Click 3 – Adding Measure As you can see I have added 2 Measures – Sum (TotalProductCost) Sum of TotalProductCost:=SUM([TotalProductCost]) Sum of SalesAmount:=SUM([SalesAmount]) Click 4 – Viewing Cube in Excel Click on Excel Symbol on Tool Bar, this…

0