Sum positive and negative numbers of a column in power BI desktop

[hemanth52130]

Hi All,

I have a column named IAA (datatype: decimal number) in the below table which have positive and negative values in it. I want to show the sum of all these values in the total (irrespective of positive or negative). The total of the IAA needs to be 7028277.40 

If i take sum instead of don't summarize it's giving some garbage values.

Please help with the solution

[v-easonf-msft · Accepted solution]

Hi, @hemanth52130 

Try measure  as below to change total value:

measure=If(HASONEVALUE(Table(Account)),sumx(Table, Table[iAA]), sumx(Table, abs(table[iAA])))

 Best Regards,
Community Support Team _ Eason
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[hemanth52130]

Hi Amit,

Thanks for the quick response. When we use ABS the values in the table are getting changes. All negative values to positive. Here my requirement is the values in the table should not change only the total needs to be sum of all the IAA column values.

[amitchandak]

@hemanth52130 , Try like

sumx(Table, abs(table[iAA]))