topic Re: How to sum up columns on a table (column is derived from DAX formula) in DAX Commands and Tips

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

Vizbaby — Wed, 29 Nov 2023 17:14:30 GMT

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.

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

adudani — Thu, 30 Nov 2023 01:39:03 GMT

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

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

Vizbaby — Thu, 30 Nov 2023 12:45:00 GMT

Youre amazing. Thank You🙌