Zero substituted for BLANK
"Zero substituted for BLANK" is one of the dax quality checks Auditabi runs on a Power BI semantic model. n measure(s) replace BLANK with 0 with a pattern such as + 0 or IF(ISBLANK(…), 0, …). It is a low-severity finding: hygiene and maintainability, worth fixing when you next touch the object. Return BLANK when there is nothing to show, and handle the display in the visual (show items with no data) when a zero is really wanted.
What is detected
n measure(s) replace BLANK with 0 with a pattern such as + 0 or IF(ISBLANK(…), 0, …). Every row of every dimension then has a value, the visual stops filtering empty combinations, and the matrix explodes in size.
Why it matters
Hygiene and maintainability. Fix when touching the object.
How to fix it
Return BLANK when there is nothing to show, and handle the display in the visual (show items with no data) when a zero is really wanted.
Reference
SQLBI: Blank handling in DAX
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