https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Dax/m-p/3854679#M150603 <P><a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="445213" data-lia-user-login="MSAYED26" class="lia-mention lia-mention-user">MSAYED26</a>&nbsp;Try:</P> <LI-CODE lang="markup">AVERAGEX(ALL('Total Mechanical Process core'),'Total Mechanical Process core'[Value])</LI-CODE> Fri, 19 Apr 2024 20:00:44 GMT Greg_Deckler 2024-04-19T20:00:44Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Dax/m-p/3854628#M150599 <P>I want to calculate average for all month ,I want The trend line change every month based on data , used&nbsp;</P><DIV><DIV><SPAN>AVERAGE CASES = </SPAN><SPAN>CALCULATE</SPAN><SPAN>(</SPAN><SPAN>AVERAGEX</SPAN><SPAN>('Total Mechanical Process core','Total Mechanical Process core'[Value]),</SPAN><SPAN>ALL</SPAN><SPAN>('Total Mechanical Process core'[Column]</SPAN><SPAN>.</SPAN><SPAN>[Month])) but not working</SPAN></DIV></DIV><P><img /></P><P> </P><P>&nbsp;</P> Fri, 19 Apr 2024 19:25:53 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Dax/m-p/3854628#M150599 MSAYED26 2024-04-19T19:25:53Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Dax/m-p/3854679#M150603 <P><a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="445213" data-lia-user-login="MSAYED26" class="lia-mention lia-mention-user">MSAYED26</a>&nbsp;Try:</P> <LI-CODE lang="markup">AVERAGEX(ALL('Total Mechanical Process core'),'Total Mechanical Process core'[Value])</LI-CODE> Fri, 19 Apr 2024 20:00:44 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Dax/m-p/3854679#M150603 Greg_Deckler 2024-04-19T20:00:44Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Dax/m-p/3854711#M150606 <P>Thank it work , but i want iteractive values with slicer&nbsp;</P><P>&nbsp;</P> Fri, 19 Apr 2024 20:15:54 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Dax/m-p/3854711#M150606 MSAYED26 2024-04-19T20:15:54Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Dax/m-p/3856813#M150668 <P><a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="445213" data-lia-user-login="MSAYED26" class="lia-mention lia-mention-user">MSAYED26</a>&nbsp;Use ALLSELECTED instead of ALL.</P> Sun, 21 Apr 2024 13:10:23 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Dax/m-p/3856813#M150668 Greg_Deckler 2024-04-21T13:10:23Z