Solved: Control Chart Assitance

brich06 · ‎08-16-2022

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 · ‎08-16-2022

@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') )

!! Power BI 101 Interview questions !! !! Master Microsoft Fabric- 36 Videos !!
Microsoft Power BI Learning Resources, 2023 !!
Learn Power BI - Full Course with Dec-2022, with Window, Index, Offset, 100+ Topics !!
Did I answer your question? Mark my post as a solution! Appreciate your Kudos !! Proud to be a Super User! !!

View solution in original post

amitchandak · ‎08-16-2022

@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') )

!! Power BI 101 Interview questions !! !! Master Microsoft Fabric- 36 Videos !!
Microsoft Power BI Learning Resources, 2023 !!
Learn Power BI - Full Course with Dec-2022, with Window, Index, Offset, 100+ Topics !!
Did I answer your question? Mark my post as a solution! Appreciate your Kudos !! Proud to be a Super User! !!

Control Chart Assitance

Helpful resources

Microsoft Fabric Learn Together

Power BI Monthly Update - April 2024

Fabric Community Update - April 2024