Calculated column that calls a measure
"Calculated column that calls a measure" is one of the performance checks Auditabi runs on a Power BI semantic model. n calculated column(s) reference a measure. It is a medium-severity finding: the model still works, but results are wrong in some filter contexts, slow, or fragile under change. Compute the value in Power Query, or express it with column arithmetic; keep measures for query time.
What is detected
n calculated column(s) reference a measure. Each row triggers a context transition, refresh time grows with the row count, and the value is frozen at refresh time.
Why it matters
Wrong in some filter contexts, slow, or fragile under change. Fix in the next iteration.
How to fix it
Compute the value in Power Query, or express it with column arithmetic; keep measures for query time.
Reference
SQLBI: Calculated columns and measures 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