How to sum up columns on a table (column is derived from DAX formula)

[Vizbaby]

Please how do i sum up the columns in yellow? the total is coming up as the total of 1997(201 and 63) instead of the entire sum from 1981. The column numbers were derived from a formula, the columns DO NOT appear on the table.

[Vizbaby]

Youre amazing. Thank You🙌

[adudani · Accepted solution]

hi @Vizbaby ,

Try creating the measure below and replace with the table name in the model:

Sumx over years  =
SUMX( 
VALUES('ALLYEARVALUETABLE'[ALLYEAR]),
[ActiveMembersCount]
)

  if this doesn't resolve the issue, please provide a sample input masking sensitive data