How do I get the average number of units sold over a period of weeks.

[Anonymous]

I used a matrix to get the sum of the total units that had been sold in a 9 week period. This gives a total of 7600 and therefore should show an average of 844.44 per week. How do I replicate this information in PowerBI? When using the average it gives me an incorrect total average. (This will be due to there being multiple entries for each week number).

This is my first post and first time using PowerBI so I may 

[v-yanjiang-msft]

Hi @Anonymous ,

Is your problem solved? If so, Would you mind accept the helpful replies as solutions? Then we are able to close the thread. More people who have the same requirement will find the solution quickly and benefit here. Thank you.

If you need more help, please feel free to let me know.

Best Regards,
Community Support Team _ kalyj

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[FarhanAhmed]

You should use Iterator Average Function to get the correct average

you DAX code should be looks like this

=AVERAGEX(Values(WeekNumber), [Total Units Sold])

[Anonymous]

Hi, when I do this is doesn't allow me to select the colomn for total units sold? 

[FarhanAhmed]

Create a measure Total Units and then use this measure in the Formula.

[Nahid_3152]

Hi @Anonymous 

Try  in a Measure

Avg =

var A = COUNT(Sheet1[WeekNumber])

var B = SUM(Sheet1[Total Unit Sold])

return

B/A

[Nahid_3152]

Hi @Anonymous  

Or u can use this 

DIVIDE(SUM('Sheet1'[Total Unit Sold]), CALCULATE(COUNT('Sheet1'[WeekNumber]), ALLSELECTED()))

Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!

Proud to be a Super User!

[Anonymous]

Hi, Both your solutions return this:

[Nahid_3152]

Hi @Anonymous 

Please see the below image