Iterator over a dimension summing a fact column
"Iterator over a dimension summing a fact column" is one of the reliability checks Auditabi runs on a Power BI semantic model. n measure(s) iterate a dimension while aggregating a column of a fact table. It is a low-severity finding: hygiene and maintainability, worth fixing when you next touch the object. Iterate the fact table, or wrap the inner aggregation in CALCULATE so each dimension row filters the fact.
What is detected
n measure(s) iterate a dimension while aggregating a column of a fact table. Without a context transition the same fact total is added for each dimension row, which multiplies the result.
Why it matters
Hygiene and maintainability. Fix when touching the object.
How to fix it
Iterate the fact table, or wrap the inner aggregation in CALCULATE so each dimension row filters the fact.
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