Rollup Dax Guide

Summary

ROLLUPGROUP: Identifies a subset of columns specified in the call to SUMMARIZE function that should be used to calculate ... ROLLUPADDISSUBTOTAL: Identifies a subset of columns specified in the call to SUMMARIZECOLUMNS function that should be ... In this video we look at how you can group your data using SUMMARIZE, and also how you can utilise different modifiers  ... GENERATE: The second table expression will be evaluated for each row in the first table. Returns the crossjoin of the first table ... DETAILROWS: Returns the table data corresponding to the DetailRows expression defined on the specified Measure. ISSUBTOTAL: Returns TRUE if the current row contains a subtotal for a specified column and FALSE otherwise. EXACT: Checks whether two text strings are exactly the same, and returns TRUE or FALSE. EXACT is case-sensitive. FIXED: Rounds a number to the specified number of decimals and returns the result as text with optional commas. NATURALINNERJOIN: Joins the Left table with right table using the Inner Join semantics. SUBSTITUTEWITHINDEX: Returns a table which represents the semijoin of two tables supplied and for which the common set of ... PRODUCT: Returns the product of the given column reference.