Need help adjusting figures in finance calculations

[RichOB]

Hi, I need the Total in the bold section of my table below to show 9,575,579.71.

The Actuals_ column is how it presents in my raw data, so it naturally minuses the -4,717,782.90 figure to get 140,013.91. I need the calculation to show it as a plus, so I made the measure below which makes it Look correct, but the Total is still subtracting the 4,717 figure.

Actuals_ABS = ABS(SUM(Table[Amount])+0)

How can this be rectified, please?

Thanks

[DataNinja777 · Accepted solution]

Hi @RichOB ,

The issue occurs because the ABS function is being applied after the aggregation, not before. Power BI is summing all values in the [Amount] column—including the negative income—and then applying ABS to that result, which leads to an incorrect total. To fix this, you need to use an iterator that applies ABS to each subtotal by type before summing them. You can do this using the SUMX function over the distinct type values so that each row-level ABS is respected in the total calculation.

Actuals_ABS_Correct = 
SUMX(
    VALUES(Table[Type]),
    ABS(SUM(Table[Amount]))
)

This way, ABS is applied individually to each type subtotal, and only then are the results summed, which will give you the correct total of 9,575,579.71 instead of the incorrect 140,013.91.

Best regards,