Creating an Average Projects Completed by Week Measure

[Yknoff]

Hi all, I am looking for some help on trying to make a measure that will show me the average weekly projects that are completed by a user throughout the year. I have been able to create a measure that will display the cumulative total of projects completed by the buyer, but I am not sure how to create a measure that will divide the cumulative total by the week number.

Below is a sample of the data I have as well as the format I would like the graph to be with the buyer being a slicer. 

Thanks in advance for any help 

[v-luwang-msft · Accepted solution]

Hi @Yknoff ,

You could try the following measure:

TEST = CALCULATE(COUNT('Table'[Buyer]),ALL('Table'))/CALCULATE(DISTINCTCOUNT('Table'[Weeknum]),ALL('Table'))

It return:

And if in your data ,the week with no data also need to calculate,you could try the below:

TEST2 = CALCULATE(COUNT('Table'[Buyer]),ALL('Table'))/CALCULATE(MAX('Table'[Weeknum]),ALL('Table'))

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

Best Regards

Lucien