ISERROR DAX Function in Power BI

The ISERROR DAX function checks whether a value is an error, and returns TRUE or FALSE.

DAX Syntax ISERROR(value)

The parameter value specified the value we want to test.

Example: Let’s create a measure named “ISERROR Measure”.

DAX

ISERROR Measure = ISERROR(1/0)

The output of the above dax code is shown below:

ISERROR dax function in Power BI

DAX

ISERROR Measure = ISERROR(1/20)

The output of the above dax code is shown below:

ISERROR dax function in Power BI