IFERROR / ISERROR in DAX
"IFERROR / ISERROR in DAX" is one of the performance checks Auditabi runs on a Power BI semantic model. n expression(s) use IFERROR or ISERROR. It is a medium-severity finding: the model still works, but results are wrong in some filter contexts, slow, or fragile under change. Remove the error path and prevent the error instead: DIVIDE for division, ISBLANK / COALESCE for missing values, data-type fixes in Power Query.
What is detected
n expression(s) use IFERROR or ISERROR. Error handling forces the engine into slow row-by-row evaluation and hides real data problems.
Why it matters
Wrong in some filter contexts, slow, or fragile under change. Fix in the next iteration.
How to fix it
Remove the error path and prevent the error instead: DIVIDE for division, ISBLANK / COALESCE for missing values, data-type fixes in Power Query.
Reference
Tabular Editor BPA: Avoid using the IFERROR function
Does your model fail this check?
Free static audit with the exact objects, no account, nothing stored.
More DAX checks
- Arithmetic or comparison on a measure that returns text
- Measure returning text in one branch and a number in another
- Share denominator clears a fact-table column instead of the dimension
- "Previous period" window overlaps the current one
- Percentage label built without ×100
- Percentages and amounts summed together