DAXPerformanceLow
Same measure evaluated twice to test for blank
"Same measure evaluated twice to test for blank" is one of the performance checks Auditabi runs on a Power BI semantic model. n measure(s) call a measure once inside ISBLANK and again to return it. It is a low-severity finding: hygiene and maintainability, worth fixing when you next touch the object. Store the value in a variable, test the variable, and return the variable.
What is detected
n measure(s) call a measure once inside ISBLANK and again to return it. The engine evaluates it twice for every cell of the visual.
Why it matters
Hygiene and maintainability. Fix when touching the object.
How to fix it
Store the value in a variable, test the variable, and return the variable.
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