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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Frequent Visitor

SUM / SUMX Column

I'm working with a combined table - Current ERP data + Historical data (.xlsx) merged by query.

I used the following formula to create a custom column for weight (also to get rid of the "-") 

My current data turns out fine 2019, 2020 but within the historical data the weight values of identical rows end up summarized.


Using SUMX leaves me with the following error message:



Any thoughts on how to solve this?

Super User
Super User

Hi @fbron ,


Try creating a measure rather than a column.


If this helps please give Kudos and mark it as a Solution! 🙂




Best Regards,

Pragati Jain

MVP logo

LinkedIn | Twitter | Blog YouTube 

Did I answer your question? Mark my post as a solution! This will help others on the forum!

Appreciate your Kudos!!

Proud to be a Super User!!

Super User
Super User

Hi @fbron ,


SUMX is an aggregator calculation the first parameter is a table and the second the calculation you need. So your measure needs to be something similar to:




If you are just trying to replaced the negative to positives have you tried the ABS formula?


Miguel Félix

Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português

Frequent Visitor

I did manage to get this done with a measure, problem is that eventually I'm in need of a running total for the weight column. 

Something like this:

Running Total.jpg

As far as I know I'm in need of a column to get to that running total, tried it with the (working) measure but couldnt get it done.



Calculating running total in a measure is slightly different to a column. 


Please check this post: 


Paul Zheng


Helpful resources

July 2024 Power BI Update

Power BI Monthly Update - July 2024

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


Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors