Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Vizbaby
Frequent Visitor

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

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_0-1701277872831.png

 

1 ACCEPTED SOLUTION
adudani
Super User
Super User

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

Did I answer your question? Mark my post as a solution, this will help others!
If my response(s) assisted you in any way, don't forget to drop me a Kudos 🙂
Kind Regards,
Avinash

View solution in original post

2 REPLIES 2
Vizbaby
Frequent Visitor

Youre amazing. Thank You🙌

adudani
Super User
Super User

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

Did I answer your question? Mark my post as a solution, this will help others!
If my response(s) assisted you in any way, don't forget to drop me a Kudos 🙂
Kind Regards,
Avinash

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors