Power BI Matrix double negative total

[lherbert501]

Hi,

I have a simple matrix which sums the total on the upper level which works correctly.

However when like below I have -4 and -9 this is totalling in at -5.

How would I get this to total with both being negative values and it to come out at -13? Would this need to be calculated differently?

-5

-4

-9

Thanks

Liam

[Anonymous]

Hi @lherbert501 ,

Thanks for the reply from Greg_Deckler .

I have tested it and can not reproduce your problem.

There are two possible influencing factors:

Make sure no filters or slicers inadvertently affect calculations.

Make sure the field is aggregation type is set to "Sum".

I would be grateful if you could provide me with pbix file, please remember not to log into your account in Power BI Desktop when uploading the pbix file.

Best Regards,
Yang
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

[lherbert501]

hi @Anonymous 

Thanks for your reply.

My calculation involves calculating 3 measures. e.g currently.

[Profit] + [Income] - [Costs].

This is what is causing the negative to go the wrong way. It's only displaying incorrect on the Report total and report sub total level.

I have included Dummy data in the image below.

Thanks

Liam

[Greg_Deckler]

@lherbert501 First, please vote for this idea: https://ideas.powerbi.com/ideas/idea/?ideaid=082203f1-594f-4ba7-ac87-bb91096c742e

This looks like a measure totals problem. Very common. See my post about it here: https://community.powerbi.com/t5/DAX-Commands-and-Tips/Dealing-with-Measure-Totals/td-p/63376

Also, this Quick Measure, Measure Totals, The Final Word should get you what you need:
https://community.powerbi.com/t5/Quick-Measures-Gallery/Measure-Totals-The-Final-Word/m-p/547907

Also: https://youtu.be/uXRriTN0cfY
And: https://youtu.be/n4TYhF2ARe8