topic Sum Certain Rows but Keep in same Column in DAX Commands and Tips https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Sum-Certain-Rows-but-Keep-in-same-Column/m-p/4776769#M182946 <P>I have a table like this:&nbsp;&nbsp;</P><TABLE border="1"><TBODY><TR><TD>Product</TD><TD>Totals</TD></TR><TR><TD><P>Data1</P></TD><TD>20</TD></TR><TR><TD>Data2</TD><TD>10</TD></TR><TR><TD>Product1</TD><TD>50</TD></TR><TR><TD>Product2</TD><TD>100</TD></TR></TBODY></TABLE><P>How could I add the Data1 and Data2 rows together and keep it in the same Product column so it's like this:</P><TABLE border="1"><TBODY><TR><TD>Product</TD><TD>Totals</TD></TR><TR><TD>Data&nbsp;</TD><TD>30</TD></TR><TR><TD>Product1</TD><TD>50</TD></TR><TR><TD>Product2</TD><TD>100</TD></TR></TBODY></TABLE> Fri, 25 Jul 2025 18:16:31 GMT BrianNeedsHelp 2025-07-25T18:16:31Z Sum Certain Rows but Keep in same Column https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Sum-Certain-Rows-but-Keep-in-same-Column/m-p/4776769#M182946 <P>I have a table like this:&nbsp;&nbsp;</P><TABLE border="1"><TBODY><TR><TD>Product</TD><TD>Totals</TD></TR><TR><TD><P>Data1</P></TD><TD>20</TD></TR><TR><TD>Data2</TD><TD>10</TD></TR><TR><TD>Product1</TD><TD>50</TD></TR><TR><TD>Product2</TD><TD>100</TD></TR></TBODY></TABLE><P>How could I add the Data1 and Data2 rows together and keep it in the same Product column so it's like this:</P><TABLE border="1"><TBODY><TR><TD>Product</TD><TD>Totals</TD></TR><TR><TD>Data&nbsp;</TD><TD>30</TD></TR><TR><TD>Product1</TD><TD>50</TD></TR><TR><TD>Product2</TD><TD>100</TD></TR></TBODY></TABLE> Fri, 25 Jul 2025 18:16:31 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Sum-Certain-Rows-but-Keep-in-same-Column/m-p/4776769#M182946 BrianNeedsHelp 2025-07-25T18:16:31Z Re: Sum Certain Rows but Keep in same Column https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Sum-Certain-Rows-but-Keep-in-same-Column/m-p/4776790#M182947 <P>Create a calculated column</P><P>&nbsp;</P><P>Category = IF ( Product[Product] IN {"Data1", "Data2}, "Data", Product[Product] )</P><P>&nbsp;</P><P>Then group this column</P><P>&nbsp;</P><P>If this helped, please consider giving kudos and mark as a solution</P><P><STRONG><a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="273" data-lia-user-login="me" class="lia-mention lia-mention-user">me</a> in replies or I'll lose your thread</STRONG></P><P>Want to check your DAX skills? <A href="https://www.linkedin.com/company/kubisco/" target="_blank">Answer my biweekly DAX challenges on the kubisco Linkedin page</A></P><P>Consider voting <A href="https://community.fabric.microsoft.com/t5/Fabric-Ideas/Power-BI-Filter-Pane-as-an-icon-on-the-right-side-bar-in-on/idi-p/4728588" target="_blank">this Power BI idea</A></P><P><STRONG>Francesco Bergamaschi</STRONG></P><P>MBA, M.Eng, M.Econ, Professor of BI</P> Fri, 25 Jul 2025 18:43:32 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Sum-Certain-Rows-but-Keep-in-same-Column/m-p/4776790#M182947 FBergamaschi 2025-07-25T18:43:32Z Re: Sum Certain Rows but Keep in same Column https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Sum-Certain-Rows-but-Keep-in-same-Column/m-p/4776821#M182953 <P>Hi&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="828752" data-lia-user-login="BrianNeedsHelp" class="lia-mention lia-mention-user">BrianNeedsHelp</a>&nbsp; an alternative approach is to create calculated column like this</P> <P>&nbsp;</P> <DIV> <DIV><SPAN>Product Group =</SPAN></DIV> <DIV><SPAN>S</SPAN><SPAN>WITCH</SPAN><SPAN>(</SPAN></DIV> <DIV><SPAN>&nbsp; &nbsp; </SPAN><SPAN>TR</SPAN><SPAN>UE</SPAN><SPAN>()</SPAN><SPAN>,</SPAN></DIV> <DIV><SPAN>&nbsp; &nbsp; 'Pr</SPAN><SPAN>oductsTable'[Pr</SPAN><SPAN>oduct] </SPAN><SPAN>IN</SPAN> <SPAN>{</SPAN><SPAN>"</SPAN><SPAN>Da</SPAN><SPAN>ta1"</SPAN><SPAN>, </SPAN><SPAN>"</SPAN><SPAN>Da</SPAN><SPAN>ta2"</SPAN><SPAN>}, </SPAN><SPAN>"Da</SPAN><SPAN>ta"</SPAN><SPAN>,</SPAN></DIV> <DIV><SPAN>&nbsp; &nbsp; 'Pro</SPAN><SPAN>ductsTable'[Pro</SPAN><SPAN>duct]</SPAN></DIV> <DIV><SPAN>)</SPAN></DIV> <DIV>&nbsp;</DIV> <DIV>&nbsp;</DIV> </DIV> Fri, 25 Jul 2025 19:39:43 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Sum-Certain-Rows-but-Keep-in-same-Column/m-p/4776821#M182953 techies 2025-07-25T19:39:43Z