Blank Dax Guide

Summary

FIRSTNONBLANK: Returns the first value in the column for which the expression has a non ISBLANK: Checks whether a value is COUNTBLANK: Counts the number of 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. ISEMPTY: Returns true if the specified table or table-expression is ROLLUPISSUBTOTAL: Pairs up the rollup groups with the column added by ROLLUPADDISSUBTOTAL. IGNORE: Tags a measure expression specified in the call to SUMMARIZECOLUMNS function to be ignored when determining the ... DISTINCTCOUNT: Counts the number of distinct values in a column. HASONEVALUE: Returns true when there's only one value in the specified column. DISTINCT: Returns distinct (unique) values in a column or from a table expression.