Information

ISINSCOPE is a DAX function that returns TRUE when the specified column is in the current scope of a hierarchy. Syntax Argument Properties Description ColumnName The … Read More

ISSUBTOTAL is a DAX function that returns TRUE if the current row contains a subtotal for a specified column, and FALSE otherwise. Syntax Argument Properties Description … Read More

ISFILTERED is a DAX function that returns TRUE when there are direct filters on the specified column. Syntax Argument Properties Description TableNameOrColumnName The table or column … Read More

HASONEVALUE is a DAX function that returns TRUE when there is only one distinct value in a specified column. Syntax Argument Properties Description ColumnName The column … Read More

ISCROSSFILTERED is a DAX function that returns TRUE when the specified table or column is cross-filtered. Syntax Argument Properties Description TableNameOrColumnName The column or table to … Read More

ERROR is a DAX function that raises a user-specified error. Syntax Argument Properties Description ErrorText The text of the error to be raised. Return Values None … Read More

HASONEFILTER is a DAX function that returns TRUE if there is exactly one filter applied to a specified table or column. Syntax Argument Properties Description ColumnName … Read More

ISTEXT is a DAX function that checks whether a value is text and returns TRUE or FALSE accordingly. Syntax Argument Properties Description Value The value you … Read More

ISODD is a DAX function that returns TRUE if a number is odd, or FALSE if it is even. Syntax Argument Properties Description Number The value … Read More

ISNONTEXT is a DAX function that checks whether a value is not text (excluding blank cells) and returns TRUE or FALSE accordingly. Syntax Argument Properties Description … Read More