Division operator instead of DIVIDE
"Division operator instead of DIVIDE" is one of the dax quality checks Auditabi runs on a Power BI semantic model. n expression(s) divide with "/". It is a low-severity finding: hygiene and maintainability, worth fixing when you next touch the object. Use DIVIDE(numerator, denominator) — it returns BLANK (or an alternate result) on zero and is optimised by the engine.
What is detected
n expression(s) divide with "/". A zero or BLANK denominator raises an error or returns infinity, and the visual shows an error instead of a blank.
Why it matters
Hygiene and maintainability. Fix when touching the object.
How to fix it
Use DIVIDE(numerator, denominator) — it returns BLANK (or an alternate result) on zero and is optimised by the engine.
Reference
Tabular Editor BPA: Use the DIVIDE function for division
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