https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Matrix-table-subtotal-problem/m-p/2749973#M84817 <P>Dear Members,<BR />&nbsp;Could you please kindly help to solve the following problem? see the picture<BR />&nbsp;i would like that the sum celds are igual to subtotal of the matrix.</P><P>&nbsp;</P><P>Best regards</P><P><img /></P><P>&nbsp;</P> Tue, 06 Sep 2022 10:22:40 GMT ChiRomeu 2022-09-06T10:22:40Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Matrix-table-subtotal-problem/m-p/2749973#M84817 <P>Dear Members,<BR />&nbsp;Could you please kindly help to solve the following problem? see the picture<BR />&nbsp;i would like that the sum celds are igual to subtotal of the matrix.</P><P>&nbsp;</P><P>Best regards</P><P><img /></P><P>&nbsp;</P> Tue, 06 Sep 2022 10:22:40 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Matrix-table-subtotal-problem/m-p/2749973#M84817 ChiRomeu 2022-09-06T10:22:40Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Matrix-table-subtotal-problem/m-p/2750137#M84821 <P>Hi&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="389075" data-lia-user-login="ChiRomeu" class="lia-mention lia-mention-user">ChiRomeu</a>&nbsp;</P> <P>please try</P> <LI-CODE lang="javascript">Count = SUMX ( CROSSJOIN ( SUMMARIZE ( Coutry, Country[Continent], Country[City] ), VALUES ( Company[Company] ), VALUES ( Products[Product] ), VALUES ( Services[Service Type] ) ), COUNTROWS ( CALCULATETABLE ( VALUES ( Customers[Customer] ) ) ) )</LI-CODE> Tue, 06 Sep 2022 11:27:42 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Matrix-table-subtotal-problem/m-p/2750137#M84821 tamerj1 2022-09-06T11:27:42Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Matrix-table-subtotal-problem/m-p/2750330#M84836 <P>thanks a lot!</P> Tue, 06 Sep 2022 12:57:27 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Matrix-table-subtotal-problem/m-p/2750330#M84836 ChiRomeu 2022-09-06T12:57:27Z