https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/PowerBi-How-to-get-grand-total-in-cluster-column/m-p/4021760#M158690 <P>I've tried two ways, it works if there is only one data table but when it comes to 2. Please help me:&nbsp;</P><P><STRONG>First way:</STRONG></P><DIV><DIV><SPAN>Total </SPAN><SPAN>by</SPAN><SPAN> Sales = </SPAN></DIV><DIV><SPAN>var</SPAN><SPAN> SalesTotal = </SPAN></DIV><DIV><SPAN>sum</SPAN><SPAN>('Sell out'[Tiền])</SPAN></DIV><DIV><SPAN>RETURN</SPAN></DIV><DIV><SPAN>if</SPAN><SPAN>(</SPAN><SPAN>isblank</SPAN><SPAN>(SalesTotal),</SPAN><SPAN>CALCULATE</SPAN><SPAN>(</SPAN><SPAN>sum</SPAN><SPAN>('Sell out'[Tiền]),</SPAN><SPAN>allexcept</SPAN><SPAN>('Sell out','Sell out'[Năm out],'Sell out'[Tháng out])),SalesTotal)</SPAN></DIV><DIV>&nbsp;</DIV><DIV><STRONG>Second:&nbsp;</STRONG><DIV><DIV><SPAN>Measure</SPAN><SPAN> =</SPAN> <SPAN>if</SPAN><SPAN>(</SPAN><SPAN>SELECTEDVALUE</SPAN><SPAN>(</SPAN><SPAN>'Table'</SPAN><SPAN>[Sales total]</SPAN><SPAN>)=</SPAN><SPAN>"Total"</SPAN><SPAN>,</SPAN><SPAN>CALCULATE</SPAN><SPAN>(</SPAN><SPAN>sum</SPAN><SPAN>(</SPAN><SPAN>'Sell out'</SPAN><SPAN>[Tiền]</SPAN><SPAN>),</SPAN><SPAN>ALLEXCEPT</SPAN><SPAN>(</SPAN><SPAN>'Sell out'</SPAN><SPAN>,</SPAN><SPAN>'Sell out'</SPAN><SPAN>[Năm out]</SPAN><SPAN>,</SPAN><SPAN>'Sell out'</SPAN><SPAN>[Tháng out]</SPAN><SPAN>)),</SPAN><SPAN>sum</SPAN><SPAN>(</SPAN><SPAN>'Sell out'</SPAN><SPAN>[Tiền]</SPAN><SPAN>))</SPAN></DIV><DIV>&nbsp;</DIV><DIV><SPAN>This is our data table:</SPAN></DIV><DIV><img /><img /><P>&nbsp;</P></DIV></DIV></DIV></DIV> Wed, 03 Jul 2024 04:31:39 GMT MinhPham0710 2024-07-03T04:31:39Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/PowerBi-How-to-get-grand-total-in-cluster-column/m-p/4021760#M158690 <P>I've tried two ways, it works if there is only one data table but when it comes to 2. Please help me:&nbsp;</P><P><STRONG>First way:</STRONG></P><DIV><DIV><SPAN>Total </SPAN><SPAN>by</SPAN><SPAN> Sales = </SPAN></DIV><DIV><SPAN>var</SPAN><SPAN> SalesTotal = </SPAN></DIV><DIV><SPAN>sum</SPAN><SPAN>('Sell out'[Tiền])</SPAN></DIV><DIV><SPAN>RETURN</SPAN></DIV><DIV><SPAN>if</SPAN><SPAN>(</SPAN><SPAN>isblank</SPAN><SPAN>(SalesTotal),</SPAN><SPAN>CALCULATE</SPAN><SPAN>(</SPAN><SPAN>sum</SPAN><SPAN>('Sell out'[Tiền]),</SPAN><SPAN>allexcept</SPAN><SPAN>('Sell out','Sell out'[Năm out],'Sell out'[Tháng out])),SalesTotal)</SPAN></DIV><DIV>&nbsp;</DIV><DIV><STRONG>Second:&nbsp;</STRONG><DIV><DIV><SPAN>Measure</SPAN><SPAN> =</SPAN> <SPAN>if</SPAN><SPAN>(</SPAN><SPAN>SELECTEDVALUE</SPAN><SPAN>(</SPAN><SPAN>'Table'</SPAN><SPAN>[Sales total]</SPAN><SPAN>)=</SPAN><SPAN>"Total"</SPAN><SPAN>,</SPAN><SPAN>CALCULATE</SPAN><SPAN>(</SPAN><SPAN>sum</SPAN><SPAN>(</SPAN><SPAN>'Sell out'</SPAN><SPAN>[Tiền]</SPAN><SPAN>),</SPAN><SPAN>ALLEXCEPT</SPAN><SPAN>(</SPAN><SPAN>'Sell out'</SPAN><SPAN>,</SPAN><SPAN>'Sell out'</SPAN><SPAN>[Năm out]</SPAN><SPAN>,</SPAN><SPAN>'Sell out'</SPAN><SPAN>[Tháng out]</SPAN><SPAN>)),</SPAN><SPAN>sum</SPAN><SPAN>(</SPAN><SPAN>'Sell out'</SPAN><SPAN>[Tiền]</SPAN><SPAN>))</SPAN></DIV><DIV>&nbsp;</DIV><DIV><SPAN>This is our data table:</SPAN></DIV><DIV><img /><img /><P>&nbsp;</P></DIV></DIV></DIV></DIV> Wed, 03 Jul 2024 04:31:39 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/PowerBi-How-to-get-grand-total-in-cluster-column/m-p/4021760#M158690 MinhPham0710 2024-07-03T04:31:39Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/PowerBi-How-to-get-grand-total-in-cluster-column/m-p/4022931#M158743 <P>pls help me</P> Wed, 03 Jul 2024 13:01:01 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/PowerBi-How-to-get-grand-total-in-cluster-column/m-p/4022931#M158743 MinhPham0710 2024-07-03T13:01:01Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/PowerBi-How-to-get-grand-total-in-cluster-column/m-p/4024393#M158854 <P>Hi&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="769726" data-lia-user-login="MinhPham0710" class="lia-mention lia-mention-user">MinhPham0710</a>&nbsp;,</P> <P>&nbsp;</P> <P>Please provide a sample of the data and the expected results so that we can better solve the problem for you.</P> <P>&nbsp;</P> <P>Best regards,<BR />Community Support Team_ Scott Chang</P> Thu, 04 Jul 2024 07:11:00 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/PowerBi-How-to-get-grand-total-in-cluster-column/m-p/4024393#M158854 Anonymous 2024-07-04T07:11:00Z