ROLLUPADDISSUBTOTAL DAX Function (Table manipulation)
Identifies a subset of columns specified in the call to SUMMARIZECOLUMNS function that should be used to calculate groups of subtotals.
Syntax
| Parameter | Attributes | Description |
|---|---|---|
| GrandtotalFilter | Optional |
Drilldown filter to be applied to the grandtotal level. |
| GroupBy_ColumnName | Repeatable |
A column to be returned. |
| Name | Repeatable |
A column name to be added. |
| DrilldownFilter | Optional Repeatable |
Drilldown filter to be applied to the current level. |
Return values
The function does not return a value. It only specifies the set of columns to be subtotaled.
Remarks
The ROLLUP function is used exclusively within SUMMARIZECOLUMNS.
The addition of the ROLLUPADDISSUBTOTAL() syntax modifies the behavior of the SUMMARIZECOUMNS function by adding roll-up/subtotal rows to the result based on the groupBy_columnName columns.
Related articles
Learn more about ROLLUPADDISSUBTOTAL in the following articles:
-
Introducing SUMMARIZECOLUMNS
This article explains how to use SUMMARIZECOLUMNS, which is a replacement of SUMMARIZE and does not require the use of ADDCOLUMNS to obtain good performance. » Read more
Related functions
Other related functions are:
Last update: Oct 20, 2018 » Contribute » Show contributors
Contributors: Alberto Ferrari, Marco Russo