topic Re: Sum of two columns in DAX Commands and Tips https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Sum-of-two-columns/m-p/4406890#M174973 <P>Hi&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="683724" data-lia-user-login="dofrancis3" class="lia-mention lia-mention-user">dofrancis3</a>&nbsp;, its just simple&nbsp;</P><DIV><DIV><SPAN>Result =</SPAN> <SPAN>'Table'</SPAN><SPAN>[DJ]</SPAN><SPAN>+</SPAN><SPAN>'Table'</SPAN><SPAN>[HR]</SPAN></DIV></DIV> Wed, 12 Feb 2025 11:16:13 GMT powerbidev123 2025-02-12T11:16:13Z Sum of two columns https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Sum-of-two-columns/m-p/4406879#M174970 <P>Dear Colleagues,</P><P>I need your help</P><P>I would like to calculate colum <FONT color="#0000FF"><STRONG>DJ</STRONG></FONT><FONT color="#FF0000">+</FONT><FONT color="#008000"><STRONG>HR</STRONG></FONT> By <U>status</U> so that i can have the result column please could you help me with the DAX Mesure.</P><P>Thank you for your support</P><P>&nbsp;</P><P><img /></P><P>&nbsp;</P><P>&nbsp;</P> Wed, 12 Feb 2025 11:08:40 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Sum-of-two-columns/m-p/4406879#M174970 dofrancis3 2025-02-12T11:08:40Z Re: Sum of two columns https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Sum-of-two-columns/m-p/4406888#M174972 <P><a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="683724" data-lia-user-login="dofrancis3" class="lia-mention lia-mention-user">dofrancis3</a>&nbsp;, Try using</P> <P>&nbsp;</P> <P>DAX<BR />TotalDJHR = SUMX(<BR />VALUES(TableName[Status]),<BR />CALCULATE(SUM(TableName[DJ]) + SUM(TableName[HR]))<BR />)</P> Wed, 12 Feb 2025 11:15:13 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Sum-of-two-columns/m-p/4406888#M174972 bhanu_gautam 2025-02-12T11:15:13Z Re: Sum of two columns https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Sum-of-two-columns/m-p/4406890#M174973 <P>Hi&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="683724" data-lia-user-login="dofrancis3" class="lia-mention lia-mention-user">dofrancis3</a>&nbsp;, its just simple&nbsp;</P><DIV><DIV><SPAN>Result =</SPAN> <SPAN>'Table'</SPAN><SPAN>[DJ]</SPAN><SPAN>+</SPAN><SPAN>'Table'</SPAN><SPAN>[HR]</SPAN></DIV></DIV> Wed, 12 Feb 2025 11:16:13 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Sum-of-two-columns/m-p/4406890#M174973 powerbidev123 2025-02-12T11:16:13Z