topic Conditional Addition in DAX Commands and Tips https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Conditional-Addition/m-p/3068194#M106326 <P>I want to summarize the risk scores of a&nbsp; number of variables. Why is this code causing trouble?:</P><P>&nbsp;</P><DIV><DIV><SPAN>Overall Risk Score = </SPAN></DIV><DIV><SPAN>(</SPAN><SPAN>SUM</SPAN><SPAN> (</SPAN><SPAN>v_QandA_RiskScore</SPAN><SPAN>[A_Risk_Score]</SPAN><SPAN>), </SPAN><SPAN><SPAN>v_QandA_RiskScore[</SPAN></SPAN><SPAN>Question_Code</SPAN><SPAN>]</SPAN><SPAN>= </SPAN><SPAN>"Q0030"</SPAN><SPAN>)</SPAN></DIV><DIV><DIV>&nbsp;</DIV><DIV>THe error I get is about the comma in the middle, but even if I remove this, it is not working.&nbsp;</DIV><DIV>&nbsp;</DIV><DIV>How can I sum the Risk Scores of multiple&nbsp;<SPAN>Question_Codes?&nbsp;</SPAN></DIV><DIV><SPAN>I assume I would need something like this:</SPAN></DIV><DIV>&nbsp;</DIV><DIV><DIV><SPAN>Overall Risk Score = </SPAN></DIV><DIV><SPAN>((</SPAN><SPAN>SUM</SPAN><SPAN> (</SPAN><SPAN>v_QandA_RiskScore</SPAN><SPAN>[A_Risk_Score]</SPAN><SPAN>), </SPAN><SPAN>v_QandA_RiskScore[</SPAN><SPAN>Question_Code</SPAN><SPAN>]</SPAN><SPAN>= </SPAN><SPAN>"Q0030"</SPAN><SPAN>)</SPAN></DIV><DIV><DIV><SPAN>+ </SPAN></DIV><DIV><SPAN>(</SPAN><SPAN>SUM</SPAN><SPAN> (</SPAN><SPAN>v_QandA_RiskScore</SPAN><SPAN>[A_Risk_Score]</SPAN><SPAN>), </SPAN><SPAN>v_QandA_RiskScore[</SPAN><SPAN>Question_Code</SPAN><SPAN>]</SPAN><SPAN>= </SPAN><SPAN>"Q0031"</SPAN><SPAN>)</SPAN></DIV><DIV><DIV><SPAN>+ </SPAN></DIV><DIV><SPAN>(</SPAN><SPAN>SUM</SPAN><SPAN> (</SPAN><SPAN>v_QandA_RiskScore</SPAN><SPAN>[A_Risk_Score]</SPAN><SPAN>), </SPAN><SPAN>v_QandA_RiskScore[</SPAN><SPAN>Question_Code</SPAN><SPAN>]</SPAN><SPAN>= </SPAN><SPAN>"Q0032"</SPAN><SPAN>))</SPAN></DIV><DIV>&nbsp;</DIV><DIV>&nbsp;</DIV></DIV></DIV></DIV><DIV>&nbsp;</DIV></DIV></DIV> Wed, 08 Feb 2023 07:59:40 GMT acg 2023-02-08T07:59:40Z Conditional Addition https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Conditional-Addition/m-p/3068194#M106326 <P>I want to summarize the risk scores of a&nbsp; number of variables. Why is this code causing trouble?:</P><P>&nbsp;</P><DIV><DIV><SPAN>Overall Risk Score = </SPAN></DIV><DIV><SPAN>(</SPAN><SPAN>SUM</SPAN><SPAN> (</SPAN><SPAN>v_QandA_RiskScore</SPAN><SPAN>[A_Risk_Score]</SPAN><SPAN>), </SPAN><SPAN><SPAN>v_QandA_RiskScore[</SPAN></SPAN><SPAN>Question_Code</SPAN><SPAN>]</SPAN><SPAN>= </SPAN><SPAN>"Q0030"</SPAN><SPAN>)</SPAN></DIV><DIV><DIV>&nbsp;</DIV><DIV>THe error I get is about the comma in the middle, but even if I remove this, it is not working.&nbsp;</DIV><DIV>&nbsp;</DIV><DIV>How can I sum the Risk Scores of multiple&nbsp;<SPAN>Question_Codes?&nbsp;</SPAN></DIV><DIV><SPAN>I assume I would need something like this:</SPAN></DIV><DIV>&nbsp;</DIV><DIV><DIV><SPAN>Overall Risk Score = </SPAN></DIV><DIV><SPAN>((</SPAN><SPAN>SUM</SPAN><SPAN> (</SPAN><SPAN>v_QandA_RiskScore</SPAN><SPAN>[A_Risk_Score]</SPAN><SPAN>), </SPAN><SPAN>v_QandA_RiskScore[</SPAN><SPAN>Question_Code</SPAN><SPAN>]</SPAN><SPAN>= </SPAN><SPAN>"Q0030"</SPAN><SPAN>)</SPAN></DIV><DIV><DIV><SPAN>+ </SPAN></DIV><DIV><SPAN>(</SPAN><SPAN>SUM</SPAN><SPAN> (</SPAN><SPAN>v_QandA_RiskScore</SPAN><SPAN>[A_Risk_Score]</SPAN><SPAN>), </SPAN><SPAN>v_QandA_RiskScore[</SPAN><SPAN>Question_Code</SPAN><SPAN>]</SPAN><SPAN>= </SPAN><SPAN>"Q0031"</SPAN><SPAN>)</SPAN></DIV><DIV><DIV><SPAN>+ </SPAN></DIV><DIV><SPAN>(</SPAN><SPAN>SUM</SPAN><SPAN> (</SPAN><SPAN>v_QandA_RiskScore</SPAN><SPAN>[A_Risk_Score]</SPAN><SPAN>), </SPAN><SPAN>v_QandA_RiskScore[</SPAN><SPAN>Question_Code</SPAN><SPAN>]</SPAN><SPAN>= </SPAN><SPAN>"Q0032"</SPAN><SPAN>))</SPAN></DIV><DIV>&nbsp;</DIV><DIV>&nbsp;</DIV></DIV></DIV></DIV><DIV>&nbsp;</DIV></DIV></DIV> Wed, 08 Feb 2023 07:59:40 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Conditional-Addition/m-p/3068194#M106326 acg 2023-02-08T07:59:40Z Re: Conditional Addition https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Conditional-Addition/m-p/3068234#M106330 <P>Hi&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="315639" data-lia-user-login="acg" class="lia-mention lia-mention-user">acg</a>&nbsp;</P> <P>Please try</P> <LI-CODE lang="javascript">Overall Risk Score = CALCULATE ( SUM ( v_QandA_RiskScore[A_Risk_Score] ), v_QandA_RiskScore[Question_Code] IN { "Q0030", "Q0031", "Q0032" } )</LI-CODE> Wed, 08 Feb 2023 08:16:16 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Conditional-Addition/m-p/3068234#M106330 tamerj1 2023-02-08T08:16:16Z