Average computed as a sum divided by a count of rows
"Average computed as a sum divided by a count of rows" is one of the reliability checks Auditabi runs on a Power BI semantic model. n measure(s) divide a sum by COUNTROWS of a different table. It is a low-severity finding: hygiene and maintainability, worth fixing when you next touch the object. Use AVERAGEX over the grain you mean, or divide by a count taken from the same table as the numerator.
What is detected
n measure(s) divide a sum by COUNTROWS of a different table. The two sides can be filtered differently, and the average changes meaning as soon as a visual groups by an attribute of only one of them.
Why it matters
Hygiene and maintainability. Fix when touching the object.
How to fix it
Use AVERAGEX over the grain you mean, or divide by a count taken from the same table as the numerator.
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