Control Chart Assitance

[brich06]

I am trying to create a control chart and I am having issues with the Average. I would like the Average Qty to relate to the average of the total reject qty.

Average Qty of Rejections = CALCULATE(AVERAGEX('Scrap Data','Scrap Data'[Reject Qty]),ALLSELECTED('Scrap Data'[Prod Date].[Date]))

[amitchandak · Accepted solution]

@brich06 , Based on that I got try like

Average Qty of Rejections = CALCULATE(AVERAGEX(Values('Scrap Data'[Prod Date]),calculate(Sum('Scrap Data'[Reject Qty]) ) ) ,ALLSELECTED('Scrap Data') )