Summining up a number of colum values

[acg]

I am summing up a number of variables, some decimals, and some integers. 

I want to create a new column ideally. the error message says: Operator or expression '( )' is not supported in this context.

I tried to remove the CALCULATE and the additional brackets. But this did not resolve the issue. 

Overall Score =

CALCULATE( SUM

 ((SUM('fact'[RiskLargest Owner]),

    SUM('fact'[Risk Meets Requirement]),

    SUM('fact'[Risk Indep Audit 0/1]),

    SUM('fact'[Deficiencies highlighted in programme audit?),

    SUM('fact'[Risk AML CFT Programme]),

    SUM('fact'[Deficiencies highlighted in audit?]),

    SUM('fact'[Lacking Identification]),

    SUM('fact'[Exception handling procedures - customer due diligence]),

    SUM('fact'[Transaction and account monitoring processes]),

    SUM('fact'[Risk PEP Customers]),

    SUM('fact'[Risk Nonres Customer]),

    SUM('fact'[Risk Non Face to Face]),

    SUM('fact'[Risk Ministerial Exemptions]),

     SUM('v_QandZ'[HighestCountryRiskScore]))

 )

[acg]

No, This does only work with calculation, but not with variables. Should be really easy, hmm. 

[FreemanZ]

hi @acg 

try something like:

Overall Score Column  =

[RiskLargest Owner]+
[Risk Meets Requirement]+
[Risk Indep Audit 0/1]+
[Deficiencies highlighted in programme audit?+
[Risk AML CFT Programme]+
[Deficiencies highlighted in audit?]+
[Lacking Identification]+
[Exception handling procedures - customer due diligence]+
[Transaction and account monitoring processes]+
[Risk PEP Customers]+
[Risk Nonres Customer]+
[Risk Non Face to Face]+
[Risk Ministerial Exemptions]+
RELATED('v_QandZ'[HighestCountryRiskScore])