Blank Dax Guide

Summary

FIRSTNONBLANK: Returns the first value in the column for which the expression has a non ALL: Returns all the rows in a table, or all the values in a column, ignoring any filters that might have been applied. ADDMISSINGITEMS: Add the rows with TOPNSKIP: Retrieves a number of rows from a table efficiently, skipping a number of rows. ISBLANK: Checks whether a value is GENERATE: The second table expression will be evaluated for each row in the first table. Returns the crossjoin of the first table ... COUNTBLANK: Counts the number of FIXED: Rounds a number to the specified number of decimals and returns the result as text with optional commas. ISEMPTY: Returns true if the specified table or table-expression is ODD: Returns number rounded up to the nearest odd integer. ROLLUPISSUBTOTAL: Pairs up the rollup groups with the column added by ROLLUPADDISSUBTOTAL. DISTINCTCOUNT: Counts the number of distinct values in a column. IGNORE: Tags a measure expression specified in the call to SUMMARIZECOLUMNS function to be ignored when determining the ...