topic Re: DAX - AVERAGEX behaviour incomprehensible ! in DAX Commands and Tips https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DAX-AVERAGEX-behaviour-incomprehensible/m-p/4792673#M183438 <P>hello&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="922237" data-lia-user-login="informer" class="lia-mention lia-mention-user">informer</a>&nbsp;</P> <P>&nbsp;</P> <P>please check if this accomodate your need.</P> <P><img /></P> <P>&nbsp;</P> <DIV>&nbsp;</DIV> <DIV><SPAN>i am not sure the result doesnt match to what you state above.</SPAN></DIV> <P>Based on your sample data above,</P> <P>1-Jan should be 3 as (2*2+1*2)/2</P> <P>2-Jan should be 126 (8*3+6*9+20*15)/3</P> <P>&nbsp;</P> <P>create a measure with following DAX.</P> <DIV> <PRE><SPAN>Average =</SPAN><BR /><SPAN>AVERAGEX</SPAN><SPAN>(</SPAN><BR /><SPAN>&nbsp; &nbsp; </SPAN><SPAN>'Table'</SPAN><SPAN>,</SPAN><BR /><SPAN>&nbsp; &nbsp; </SPAN><SPAN>'Table'</SPAN><SPAN>[quantity_sold]</SPAN><SPAN>*</SPAN><SPAN>'Table'</SPAN><SPAN>[unit_price]</SPAN><BR /><SPAN>)</SPAN></PRE> <DIV>&nbsp;</DIV> <DIV><SPAN>Hope this will help.<BR />Thank you.</SPAN></DIV> </DIV> Mon, 11 Aug 2025 05:00:35 GMT Irwan 2025-08-11T05:00:35Z DAX - AVERAGEX behaviour incomprehensible ! https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DAX-AVERAGEX-behaviour-incomprehensible/m-p/4792498#M183431 <P>Hi,</P><P>&nbsp;</P><P>2 tables&nbsp;</P><P>Sales rows (please don't focus on values of&nbsp;transaction_id, no consequences on my question)</P><P>Calandar</P><P>&nbsp;</P><P>I calculated&nbsp;</P><DIV><DIV><SPAN>Turnover =</SPAN> <SPAN>SUMX</SPAN><SPAN>(</SPAN><SPAN>'Sales rows'</SPAN><SPAN>, </SPAN><SPAN>'Sales rows'</SPAN><SPAN>[quantity_sold]</SPAN><SPAN> * </SPAN><SPAN>'Sales rows'</SPAN><SPAN>[unit_price]</SPAN><SPAN>)</SPAN></DIV><DIV><DIV><DIV><SPAN>Average Daily Turnover EXPR =</SPAN> <SPAN>AVERAGEX</SPAN><SPAN>(</SPAN><SPAN>VALUES</SPAN><SPAN>(</SPAN><SPAN>dCalendar</SPAN><SPAN>[transaction_date]</SPAN><SPAN>), </SPAN><SPAN>SUMX</SPAN><SPAN> (</SPAN><SPAN>'Sales rows'</SPAN><SPAN>,</SPAN><SPAN>'S</SPAN><SPAN>ales rows'</SPAN><SPAN>[quantity_sold]</SPAN><SPAN> * </SPAN><SPAN>'Sales rows'</SPAN><SPAN>[unit_price]</SPAN><SPAN>))</SPAN></DIV></DIV></DIV></DIV><DIV><DIV><SPAN>Average Daily Turnover MESURE =</SPAN> <SPAN>AVERAGEX</SPAN><SPAN>(</SPAN><SPAN>VALUES</SPAN><SPAN>(</SPAN><SPAN>dCalendar</SPAN><SPAN>[transaction_date]</SPAN><SPAN>),</SPAN><SPAN>[Turnover]</SPAN><SPAN>)</SPAN></DIV><DIV>&nbsp;</DIV><DIV>And <SPAN>Average Daily Turnover</SPAN>&nbsp;values on charts are just a nonsense because all of them are same with wrong values !</DIV><DIV>&nbsp;</DIV><DIV><SPAN>I expected for Average Daily Turnover for&nbsp;</SPAN></DIV><UL><LI><SPAN>01 january 2019 : 10 = (2*2 + 1*2 + 8*3 )/3 but the result is 30</SPAN></LI><LI><SPAN>01 february 2019 : 118= (6*9 + 15*30)/3 but the result is 354</SPAN></LI></UL><DIV>Any idea for helping me to understand the charts belows ?</DIV><DIV><SPAN><SPAN><img /></SPAN></SPAN><P>Thanks by advanvce for any help !</P></DIV><DIV>&nbsp;</DIV></DIV><TABLE><TBODY><TR><TD>transaction_id</TD><TD>OrderDate</TD><TD>store_id</TD><TD>customer_id</TD><TD>product_id</TD><TD>quantity_sold</TD><TD>unit_price</TD><TD>staff_id</TD></TR><TR><TD>390</TD><TD>01/01/2019</TD><TD>5</TD><TD>5658</TD><TD>22</TD><TD>2</TD><TD>2</TD><TD>12</TD></TR><TR><TD>1228</TD><TD>01/01/2019</TD><TD>5</TD><TD>5197</TD><TD>22</TD><TD>1</TD><TD>2</TD><TD>30</TD></TR><TR><TD>1644</TD><TD>02/01/2019</TD><TD>5</TD><TD>5247</TD><TD>22</TD><TD>8</TD><TD>3</TD><TD>12</TD></TR><TR><TD>390</TD><TD>02/01/2019</TD><TD>5</TD><TD>5658</TD><TD>22</TD><TD>6</TD><TD>9</TD><TD>12</TD></TR><TR><TD>1228</TD><TD>02/01/2019</TD><TD>5</TD><TD>5197</TD><TD>22</TD><TD>20</TD><TD>15</TD><TD>30</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>Calandar</P><TABLE border="0" cellspacing="0" cellpadding="0"><TBODY><TR><TD>Transaction_Date</TD></TR><TR><TD>01/01/2019</TD></TR><TR><TD>02/01/2019</TD></TR><TR><TD>03/01/2019</TD></TR><TR><TD>04/01/2019</TD></TR><TR><TD>05/01/2019</TD></TR><TR><TD>06/01/2019</TD></TR><TR><TD>07/01/2019</TD></TR><TR><TD>08/01/2019</TD></TR><TR><TD>09/01/2019</TD></TR><TR><TD>10/01/2019</TD></TR><TR><TD>11/01/2019</TD></TR><TR><TD>12/01/2019</TD></TR><TR><TD>13/01/2019</TD></TR><TR><TD>14/01/2019</TD></TR><TR><TD>15/01/2019</TD></TR><TR><TD>16/01/2019</TD></TR><TR><TD>17/01/2019</TD></TR><TR><TD>18/01/2019</TD></TR><TR><TD>19/01/2019</TD></TR><TR><TD>20/01/2019</TD></TR><TR><TD>21/01/2019</TD></TR><TR><TD>22/01/2019</TD></TR><TR><TD>23/01/2019</TD></TR><TR><TD>24/01/2019</TD></TR><TR><TD>25/01/2019</TD></TR><TR><TD>26/01/2019</TD></TR><TR><TD>27/01/2019</TD></TR><TR><TD>28/01/2019</TD></TR><TR><TD>29/01/2019</TD></TR><TR><TD>30/01/2019</TD></TR><TR><TD>31/01/2019</TD></TR><TR><TD>01/02/2019</TD></TR><TR><TD>02/02/2019</TD></TR><TR><TD>03/02/2019</TD></TR><TR><TD>04/02/2019</TD></TR><TR><TD>05/02/2019</TD></TR><TR><TD>06/02/2019</TD></TR><TR><TD>07/02/2019</TD></TR><TR><TD>08/02/2019</TD></TR><TR><TD>09/02/2019</TD></TR><TR><TD>10/02/2019</TD></TR><TR><TD>11/02/2019</TD></TR><TR><TD>12/02/2019</TD></TR><TR><TD>13/02/2019</TD></TR><TR><TD>14/02/2019</TD></TR><TR><TD>15/02/2019</TD></TR><TR><TD>16/02/2019</TD></TR><TR><TD>17/02/2019</TD></TR><TR><TD>18/02/2019</TD></TR><TR><TD>19/02/2019</TD></TR><TR><TD>20/02/2019</TD></TR><TR><TD>21/02/2019</TD></TR><TR><TD>22/02/2019</TD></TR><TR><TD>23/02/2019</TD></TR><TR><TD>24/02/2019</TD></TR><TR><TD>25/02/2019</TD></TR><TR><TD>26/02/2019</TD></TR><TR><TD>27/02/2019</TD></TR><TR><TD>28/02/2019</TD></TR></TBODY></TABLE> Sun, 17 Aug 2025 16:50:33 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DAX-AVERAGEX-behaviour-incomprehensible/m-p/4792498#M183431 informer 2025-08-17T16:50:33Z Re: DAX - AVERAGEX behaviour incomprehensible ! https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DAX-AVERAGEX-behaviour-incomprehensible/m-p/4792673#M183438 <P>hello&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="922237" data-lia-user-login="informer" class="lia-mention lia-mention-user">informer</a>&nbsp;</P> <P>&nbsp;</P> <P>please check if this accomodate your need.</P> <P><img /></P> <P>&nbsp;</P> <DIV>&nbsp;</DIV> <DIV><SPAN>i am not sure the result doesnt match to what you state above.</SPAN></DIV> <P>Based on your sample data above,</P> <P>1-Jan should be 3 as (2*2+1*2)/2</P> <P>2-Jan should be 126 (8*3+6*9+20*15)/3</P> <P>&nbsp;</P> <P>create a measure with following DAX.</P> <DIV> <PRE><SPAN>Average =</SPAN><BR /><SPAN>AVERAGEX</SPAN><SPAN>(</SPAN><BR /><SPAN>&nbsp; &nbsp; </SPAN><SPAN>'Table'</SPAN><SPAN>,</SPAN><BR /><SPAN>&nbsp; &nbsp; </SPAN><SPAN>'Table'</SPAN><SPAN>[quantity_sold]</SPAN><SPAN>*</SPAN><SPAN>'Table'</SPAN><SPAN>[unit_price]</SPAN><BR /><SPAN>)</SPAN></PRE> <DIV>&nbsp;</DIV> <DIV><SPAN>Hope this will help.<BR />Thank you.</SPAN></DIV> </DIV> Mon, 11 Aug 2025 05:00:35 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DAX-AVERAGEX-behaviour-incomprehensible/m-p/4792673#M183438 Irwan 2025-08-11T05:00:35Z Re: DAX - AVERAGEX behaviour incomprehensible ! https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DAX-AVERAGEX-behaviour-incomprehensible/m-p/4792742#M183439 <P>Hi Irwan,<BR />Thanks so much for your help and solution which is absolutly strategic for me. <span class="lia-unicode-emoji" title=":thumbs_up:">👍</span><span class="lia-unicode-emoji" title=":right_facing_fist:">🤜</span><span class="lia-unicode-emoji" title=":left_facing_fist:">🤛</span></P><P>You make my day&nbsp;<span class="lia-unicode-emoji" title=":smiling_face_with_sunglasses:">😎</span></P> Mon, 11 Aug 2025 06:30:11 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DAX-AVERAGEX-behaviour-incomprehensible/m-p/4792742#M183439 informer 2025-08-11T06:30:11Z Re: DAX - AVERAGEX behaviour incomprehensible ! https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DAX-AVERAGEX-behaviour-incomprehensible/m-p/4792823#M183441 <P>Hello <a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="922237" data-lia-user-login="informer" class="lia-mention lia-mention-user">informer</a>&nbsp;</P> <P>&nbsp;</P> <P>Glad to be a help.</P> <P>Thank you.</P> Mon, 11 Aug 2025 07:31:43 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DAX-AVERAGEX-behaviour-incomprehensible/m-p/4792823#M183441 Irwan 2025-08-11T07:31:43Z