Forum Discussion
Power BI Matrix double negative total
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
3 Replies
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/n4TYhF2ARe8Hi 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 TeamIf 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!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
