Forum Discussion

Seth4040's avatar
Seth4040
Regular Visitor
1 year ago

Average Completion by Filter

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.

 

 

 

Need Help

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    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's avatar
      Seth4040
      Regular Visitor
      1 year ago

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

       

      ProjectCP DateYear-Wk
      3943054Thursday, February 3, 20222022-05