https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Average-of-production-by-date-and-shift/m-p/3697044#M143767 <P>Hi,&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="689517" data-lia-user-login="mariba" class="lia-mention lia-mention-user">mariba</a>&nbsp;</P> <P>&nbsp;</P> <P>Average Production by Shift = <BR />AVERAGEX(<BR />KEEPFILTERS(VALUES('Production'[Shift])),<BR />CALCULATE(<BR />[Quantity (m2) Output],<BR />REMOVEFILTERS('Calendar'[Date]) // Optionally remove date filter if you want the average across all dates<BR />)<BR />)</P> Tue, 13 Feb 2024 17:50:53 GMT rubayatyasmin 2024-02-13T17:50:53Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Average-of-production-by-date-and-shift/m-p/3696628#M143766 <P>Hi there,</P><P>&nbsp;</P><P>Im trying to calculate the average of production by date and shift.</P><P>Each day has 1, 2 or three shifts. Its not fixed.</P><P>For the average of production by date I used this:</P><P>&nbsp;</P><DIV><DIV><SPAN>Quantity (m2) ΜΟ =</SPAN></DIV><DIV><SPAN>AVERAGEX</SPAN><SPAN>(</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; </SPAN><SPAN>KEEPFILTERS</SPAN><SPAN>(</SPAN><SPAN>VALUES</SPAN><SPAN>(</SPAN><SPAN>'Calendar'</SPAN><SPAN>[Date]</SPAN><SPAN>)),</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; </SPAN><SPAN>CALCULATE</SPAN><SPAN>(</SPAN><SPAN>[Quantity (m2) Output]</SPAN><SPAN>)</SPAN></DIV><DIV><SPAN>)</SPAN></DIV><DIV>&nbsp;</DIV><DIV><SPAN>But now I need the average by shift.</SPAN></DIV><DIV>&nbsp;</DIV><DIV><SPAN>Any ideas?</SPAN></DIV><DIV>&nbsp;</DIV><DIV><SPAN>Thank you in advance!</SPAN></DIV></DIV> Tue, 13 Feb 2024 14:38:22 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Average-of-production-by-date-and-shift/m-p/3696628#M143766 mariba 2024-02-13T14:38:22Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Average-of-production-by-date-and-shift/m-p/3697044#M143767 <P>Hi,&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="689517" data-lia-user-login="mariba" class="lia-mention lia-mention-user">mariba</a>&nbsp;</P> <P>&nbsp;</P> <P>Average Production by Shift = <BR />AVERAGEX(<BR />KEEPFILTERS(VALUES('Production'[Shift])),<BR />CALCULATE(<BR />[Quantity (m2) Output],<BR />REMOVEFILTERS('Calendar'[Date]) // Optionally remove date filter if you want the average across all dates<BR />)<BR />)</P> Tue, 13 Feb 2024 17:50:53 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Average-of-production-by-date-and-shift/m-p/3697044#M143767 rubayatyasmin 2024-02-13T17:50:53Z