CALCULATE nested inside CALCULATE
"CALCULATE nested inside CALCULATE" is one of the dax quality checks Auditabi runs on a Power BI semantic model. n expression(s) nest CALCULATE directly inside another CALCULATE. It is a medium-severity finding: the model still works, but results are wrong in some filter contexts, slow, or fragile under change. Flatten to one CALCULATE with all the filter arguments, or name the intermediate results with variables so the evaluation order is explicit.
What is detected
n expression(s) nest CALCULATE directly inside another CALCULATE. Filter arguments of the inner call are applied after the outer ones, and the order is rarely what the author intended.
Why it matters
Wrong in some filter contexts, slow, or fragile under change. Fix in the next iteration.
How to fix it
Flatten to one CALCULATE with all the filter arguments, or name the intermediate results with variables so the evaluation order is explicit.
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