question

saujosai-0847 avatar image
0 Votes"
saujosai-0847 asked Ehren answered

Division by monthly total giving inaccurate results

I have a line chart which shows accuracy over time.
The measure is calculated as Percent Errors = DIVIDE(SUM('Audit - Move Ins'[Mistake Count]),COUNTROWS('Audit - Move Ins'))
Taking the number of move ins with errors in a month and dividing by the total move ins for the month. The tool tip shows the SUM of mistake count and the total number of move ins.

Almost all of the values are close, but wrong. For example:
![122081-image.png][1]


You can see that there were 20 move ins with 9 errors in August. However 9/20 = 45%, not 40.91% as shown.

One of the months is correct, though:

![122056-image.png][2]

Why is this happening and how do I fix it?
[1]: /answers/storage/attachments/122081-image.png
[2]: /answers/storage/attachments/122056-image.png


power-query-not-supported
image.png (30.8 KiB)
image.png (23.8 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

Ehren avatar image
0 Votes"
Ehren answered

This appears to be a DAX question, not one related to Power Query or M. I'd suggest you post it over in the Power BI Community site.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.