https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Dynamic-Sum-of-Averages/m-p/3026651#M103234 <P>Hello,</P><P>This is the data sample</P><TABLE><TBODY><TR><TD>Client</TD><TD>&nbsp;heures_quantity</TD><TD>duree_presta</TD><TD>€ HT Signes</TD><TD>Premier key_entry_client</TD></TR><TR><TD>A</TD><TD>16</TD><TD>284</TD><TD>4629.2</TD><TD>26/09/202271378</TD></TR><TR><TD>B</TD><TD>28</TD><TD>179</TD><TD>4522.73</TD><TD>03/01/202316723837</TD></TR><TR><TD>B</TD><TD>84</TD><TD>304</TD><TD>21361.07</TD><TD>10/03/202216723837</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>Here is a representation in the matrix :</P><P><img /></P><P>Subtotal 1 should equals 16</P><P>Subtotal 2 should equal 56 (average of the 2 values of its category)</P><P>Grand total should equal 72 (56+16)</P><P>The date filtering is important.&nbsp;</P><P>I tried to group by client but I lost the granularity of the date and therefore cannot filter anymore</P><P>Please advise me a solution in DAX.</P><P>&nbsp;</P><P>Regards</P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P> Tue, 17 Jan 2023 17:36:49 GMT antoinersw 2023-01-17T17:36:49Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Dynamic-Sum-of-Averages/m-p/3026651#M103234 <P>Hello,</P><P>This is the data sample</P><TABLE><TBODY><TR><TD>Client</TD><TD>&nbsp;heures_quantity</TD><TD>duree_presta</TD><TD>€ HT Signes</TD><TD>Premier key_entry_client</TD></TR><TR><TD>A</TD><TD>16</TD><TD>284</TD><TD>4629.2</TD><TD>26/09/202271378</TD></TR><TR><TD>B</TD><TD>28</TD><TD>179</TD><TD>4522.73</TD><TD>03/01/202316723837</TD></TR><TR><TD>B</TD><TD>84</TD><TD>304</TD><TD>21361.07</TD><TD>10/03/202216723837</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>Here is a representation in the matrix :</P><P><img /></P><P>Subtotal 1 should equals 16</P><P>Subtotal 2 should equal 56 (average of the 2 values of its category)</P><P>Grand total should equal 72 (56+16)</P><P>The date filtering is important.&nbsp;</P><P>I tried to group by client but I lost the granularity of the date and therefore cannot filter anymore</P><P>Please advise me a solution in DAX.</P><P>&nbsp;</P><P>Regards</P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P> Tue, 17 Jan 2023 17:36:49 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Dynamic-Sum-of-Averages/m-p/3026651#M103234 antoinersw 2023-01-17T17:36:49Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Dynamic-Sum-of-Averages/m-p/3026687#M103237 <P><img /></P> <P>&nbsp;</P> Tue, 17 Jan 2023 17:59:15 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Dynamic-Sum-of-Averages/m-p/3026687#M103237 CNENFRNL 2023-01-17T17:59:15Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Dynamic-Sum-of-Averages/m-p/3028107#M103340 <P>thanks a lot it works like a charm</P> Wed, 18 Jan 2023 08:57:27 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Dynamic-Sum-of-Averages/m-p/3028107#M103340 antoinersw 2023-01-18T08:57:27Z