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 FIXED: Rounds a number to the specified number of decimals and returns the result as text with optional commas. ISBLANK: Checks whether a value is TOPNSKIP: Retrieves a number of rows from a table efficiently, skipping a number of rows. COUNTBLANK: Counts the number of ISEMPTY: Returns true if the specified table or table-expression is SQRT: Returns the square root of a number. ROLLUPISSUBTOTAL: Pairs up the rollup groups with the column added by ROLLUPADDISSUBTOTAL. GENERATE: The second table expression will be evaluated for each row in the first table. Returns the crossjoin of the first table ... ODD: Returns number rounded up to the nearest odd integer.