topic Re: Control Chart Assitance in DAX Commands and Tips https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Control-Chart-Assitance/m-p/2705060#M82000 <P><a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="427567" data-lia-user-login="brich06" class="lia-mention lia-mention-user">brich06</a> , Based on that I got try like</P> <P>&nbsp;</P> <P>Average Qty of Rejections = CALCULATE(AVERAGEX(Values('Scrap Data'[Prod Date]),calculate(Sum('Scrap Data'[Reject Qty]) ) ) ,ALLSELECTED('Scrap Data') )</P> Wed, 17 Aug 2022 04:39:06 GMT amitchandak 2022-08-17T04:39:06Z Control Chart Assitance https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Control-Chart-Assitance/m-p/2704562#M81979 <P>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.</P><P>&nbsp;</P><DIV><DIV><SPAN>Average Qty of Rejections = </SPAN><SPAN>CALCULATE</SPAN><SPAN>(</SPAN><SPAN>AVERAGEX</SPAN><SPAN>(</SPAN><SPAN>'Scrap Data'</SPAN><SPAN>,</SPAN><SPAN>'Scrap Data'</SPAN><SPAN>[Reject Qty]</SPAN><SPAN>),</SPAN><SPAN>ALLSELECTED</SPAN><SPAN>(</SPAN><SPAN>'Scrap Data'</SPAN><SPAN>[Prod Date]</SPAN><SPAN>.</SPAN><SPAN>[Date]</SPAN><SPAN>))</SPAN></DIV><DIV>&nbsp;</DIV><DIV><img /><P>&nbsp;</P></DIV></DIV> Tue, 16 Aug 2022 22:31:20 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Control-Chart-Assitance/m-p/2704562#M81979 brich06 2022-08-16T22:31:20Z Re: Control Chart Assitance https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Control-Chart-Assitance/m-p/2705060#M82000 <P><a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="427567" data-lia-user-login="brich06" class="lia-mention lia-mention-user">brich06</a> , Based on that I got try like</P> <P>&nbsp;</P> <P>Average Qty of Rejections = CALCULATE(AVERAGEX(Values('Scrap Data'[Prod Date]),calculate(Sum('Scrap Data'[Reject Qty]) ) ) ,ALLSELECTED('Scrap Data') )</P> Wed, 17 Aug 2022 04:39:06 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Control-Chart-Assitance/m-p/2705060#M82000 amitchandak 2022-08-17T04:39:06Z