SUM / SUMX Column

Question

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?

mfelix · Answer

Hi&nbsp;fbron&nbsp;,
&nbsp;
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:
&nbsp;
SUMX(Table;SUM(Table[Weight))
&nbsp;
If you are just trying to replaced the negative to positives have you tried the ABS formula?

pragati11 · Answer

Hi&nbsp;fbron&nbsp;,&nbsp;Try creating a measure rather than a column.&nbsp;If this helps please give Kudos and mark it as a Solution! 🙂&nbsp;Thanks,Pragati

fbron · Answer

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:

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.

anonymous · Answer

fbron&nbsp;&nbsp;Calculating running total in a measure is slightly different to a column.&nbsp;&nbsp;Please check this post:&nbsp;https://community.powerbi.com/t5/Desktop/Create-Running-Total-On-A-Calculated-Measure/td-p/164202&nbsp;&nbsp;Paul Zheng&nbsp;

Forum Discussion

SUM / SUMX Column

4 Replies

Related content

SumX

SUMX & FILTER or SUM & CALCULATE: Best practice for summing subset of columns

CALCULATE SUM vs. SUMX RELATEDTABLE

SUMX

SUMX works, but not CALCULATE SUM