Average Completion by Filter

[Seth4040]

I am looking to get the average of jobs completed per each week and also when changing the report that shows the chart that the average would be average by the weeks showing on report.  Right now I have an the following 

Average = CALCULATE(COUNT('CP Jobs'[Project]),ALL('CP Jobs'))/CALCULATE(DISTINCTCOUNT('CP Jobs'[Year-Wk]),ALL('CP Jobs')). I feel like this isn't quite adding up.  I also have a screen shot below of the report.  Thanks.

 

 

[v-jialongy-msft]

Hi @Seth4040 

Please provide sample data that fully covers your issue and the expected outcome based on the sample data you provided.

Best Regards,

Jayleny

[Seth4040]

Here you go....This is the data trying to get average completion per week, year, or whatever I have filtered.

Project	CP Date	Year-Wk
3943054	Thursday, February 3, 2022	2022-05