Forum Discussion

acg's avatar
acg
Resolver I
3 years ago
Solved

Conditional Addition

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"))
 
 
 
DAX
  • tamerj1's avatar
    tamerj1
    3 years ago

    Hi acg 

    Please try

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

1 Reply

  • tamerj1's avatar
    tamerj1
    Community Champion
    3 years ago

    Hi acg 

    Please try

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