Inconsistent Sum/Total in Matrix

[Msampedro]

Hello all,

Need help one more time.

I have the below inconsistent Sum/Total in a Matrix. As you can see Total Net sales = 30.9M. When adding in raws a material breakdown, despite of having the same total (30.9M), in reality the sum of ech amount = 29.1M

Just below the capture I have added the table in values so you can check the actual total by material is 29.1M - Any idea on how to solve it? Many thanks in advance!

14,419,175.08	Material 1
5,544,075.85	Material 2
2,958,767.06	Material 3
2,687,145.06	Material 4
2,201,734.03	Material 5
1,239,628.95	Material 6
1,190,072.46	Material 7
-              325,140.31	Material 8
29,915,458.18	Total

Regards,

Miguel

[MFelix]

Hi @Msampedro ,

Can you please share what is the calculation you are using to get this values?

I believe this is a context based the sum of values that are dependent on other calculations may return incorrect results in aggregations at different levels depending on the aggregator column.

Can you please share a mockup data or sample of your PBIX file. You can use a onedrive, google drive, we transfer or similar link to upload your files.

If the information is sensitive please share it trough private message.