Detailrows Dax Guide

Summary

TOPNSKIP: Retrieves a number of rows from a table efficiently, skipping a number of rows. ROLLUPISSUBTOTAL: Pairs up the rollup groups with the column added by ROLLUPADDISSUBTOTAL. ADDMISSINGITEMS: Add the rows with empty measure values back. ISSELECTEDMEASURE: Returns true if one of the specified measures is currently being evaluated. SAMPLE: Returns a sample subset from a given table expression. ROLLUPADDISSUBTOTAL: Identifies a subset of columns specified in the call to SUMMARIZECOLUMNS function that should be ... IGNORE: Tags a measure expression specified in the call to SUMMARIZECOLUMNS function to be ignored when determining the ... DISTINCT: Returns distinct (unique) values in a column or from a table expression. REPT: Repeats text a given number of times. Use REPT to fill a cell with a number of instances of a text string. DATATABLE: Returns a table with data defined inline. SEARCH: Returns the starting position of one text string within another text string. SEARCH is not case-sensitive, but it is ... PERMUT: Returns the number of permutations for a given number of objects that can be selected from number objects. PATH: Returns a string that contains a delimited list of IDs, starting with the top/root of a hierarchy.