Conditional Addition

[acg]

I want to summarize the risk scores of a  number of variables. Why is this code causing trouble?:

Overall Risk Score =

(SUM (v_QandA_RiskScore[A_Risk_Score]), v_QandA_RiskScore[Question_Code]= "Q0030")

THe error I get is about the comma in the middle, but even if I remove this, it is not working. 

How can I sum the Risk Scores of multiple Question_Codes? 

I assume I would need something like this:

Overall Risk Score =

((SUM (v_QandA_RiskScore[A_Risk_Score]), v_QandA_RiskScore[Question_Code]= "Q0030")

+

(SUM (v_QandA_RiskScore[A_Risk_Score]), v_QandA_RiskScore[Question_Code]= "Q0031")

+

(SUM (v_QandA_RiskScore[A_Risk_Score]), v_QandA_RiskScore[Question_Code]= "Q0032"))

[tamerj1 · Accepted solution]

Hi @acg 

Please try

Overall Risk Score =
CALCULATE (
    SUM ( v_QandA_RiskScore[A_Risk_Score] ),
    v_QandA_RiskScore[Question_Code] IN { "Q0030", "Q0031", "Q0032" }
)