Downloads
DAXInformationIntermediate

ISERROR

Returns TRUE when a calculation returns an error.

Syntax
ISERROR(<value>)

Returns: TRUE or FALSE (a scalar).

What it does

ISERROR tests whether an expression fails with an error. It returns TRUE only for errors, and FALSE for numbers, text and blanks. Use it to find the rows where a calculation breaks, such as a conversion that cannot read a note in an amount column, so that you can count or list the failures instead of hiding them.

Syntax and arguments

Example

A conversion of imported text amounts sometimes fails. Rather than hide the failures with IFERROR, the reconciliation counts them so the team can see how many rows need attention.

Amount Failed = ISERROR(VALUE(Imports[AmountText]))

Rows that convert return FALSE. Rows with a note such as "pending" return TRUE because VALUE raises an error on them. A card that counts the TRUE rows shows the number of failed lines.

Example: a second, different use

Count how many imported amounts fail to convert, for a row that the import team must fix:

Failed Amounts =
CALCULATE(
    COUNTROWS(Imports),
    FILTER(
        Imports,
        ISERROR(VALUE(Imports[AmountText]))
    )
)

The count is a diagnostic. It shows how much of the import is unusable, and the same test can be placed in a calculated column to list the rows.

Things to watch

In business terms

ISERROR is the diagnostic test that a finance modeler uses to find broken data before a number is published. It turns a silent failure into a count the reviewer can act on. Hiding errors with a fallback without counting them is a common audit finding.

Related functions

All DAX functions · View as Markdown · DAX fundamentals