CALCULATE with no filter argument
"CALCULATE with no filter argument" is one of the dax quality checks Auditabi runs on a Power BI semantic model. n expression(s) call CALCULATE with a single argument. It is a low-severity finding: hygiene and maintainability, worth fixing when you next touch the object. Remove CALCULATE when it changes nothing, or keep it and add a comment when the context transition is the point.
What is detected
n expression(s) call CALCULATE with a single argument. It only performs a context transition, which is either unnecessary in a measure or a subtle intent that the next reader will miss.
Why it matters
Hygiene and maintainability. Fix when touching the object.
How to fix it
Remove CALCULATE when it changes nothing, or keep it and add a comment when the context transition is the point.
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