Forum Discussion

acg's avatar
acg
Icon for Resolver I rankResolver 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]=...
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" }
)
tamerj1's avatar
tamerj1
Icon for Community Champion rankCommunity 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" }
)