topic Re: Summining up a number of colum values in DAX Commands and Tips

Summining up a number of colum values

acg — Fri, 03 Mar 2023 01:08:40 GMT

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]))

)

Re: Summining up a number of colum values

FreemanZ — Fri, 03 Mar 2023 01:35:26 GMT

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])

Re: Summining up a number of colum values

acg — Fri, 03 Mar 2023 04:22:26 GMT

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