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