Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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.
Comments
- Anonymous
September 30, 2013
We can use ROLLUPGROUP inside ROLLUP in order to avoid partial subtotals.