Average of an average
"Average of an average" is one of the reliability checks Auditabi runs on a Power BI semantic model. n measure(s) average a column that already holds an average, or average another average 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 average from the two underlying totals with DIVIDE, at the grain of the visual.
What is detected
n measure(s) average a column that already holds an average, or average another average measure. The result is not the average of the underlying population unless every group has the same size.
Why it matters
Wrong in some filter contexts, slow, or fragile under change. Fix in the next iteration.
How to fix it
Compute the average from the two underlying totals with DIVIDE, at the grain of the visual.
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