Rollupgroup Dax Guide

Summary

ROLLUPISSUBTOTAL: Pairs up the rollup groups with the column added by ROLLUPADDISSUBTOTAL. ROLLUP: Identifies a subset of columns specified in the call to SUMMARIZE function that should be used to calculate subtotals. ROLLUPADDISSUBTOTAL: Identifies a subset of columns specified in the call to SUMMARIZECOLUMNS function that should be ... SUMMARIZE: Creates a summary of the input table grouped by the specified columns. DETAILROWS: Returns the table data corresponding to the DetailRows expression defined on the specified Measure. SUBSTITUTEWITHINDEX: Returns a table which represents the semijoin of two tables supplied and for which the common set of ... NONVISUAL: Mark the filter as NonVisual. ROW: Returns a single row table with new columns specified by the DAX expressions. GROUPBY: Creates a summary the input table grouped by the specified columns. PERMUT: Returns the number of permutations for a given number of objects that can be selected from number objects. ISINSCOPE: Returns true when the specified column is the level in a hierarchy of levels. In this video we look at how you can group your data using SUMMARIZE, and also how you can utilise different modifiers  ...