Help with weighted average

[vgarciasouza]

Hello community.

The measure Current MTD Average on the image is calculating correctly for each week, but the total of it is incorrec, beacause it should be the sum of all weeks (9,738) divided by weeks (5) = 1,957. How can I do this?

Thanks

[lbendlin]

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).

Do not include sensitive information or anything not related to the issue or question.

If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...

Please show the expected outcome based on the sample data you provided.

Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...