Forum Discussion

lherbert501's avatar
lherbert501
Icon for Post Prodigy rankPost Prodigy
2 years ago

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 tota...
Need Help
Anonymous's avatar
Anonymous
Not applicable
2 years ago

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's avatar
lherbert501
Icon for Post Prodigy rankPost Prodigy
2 years ago

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