Row Totals are greater than Total

[jimrosser]

Hi, my row sub-totals in my PBI table matrix are greater than my grand total.

I think it has to do with my measure not accounting for the shipping type properly, I think it should take into account the category as well but I'm not sure how to account for that maybe a SUMX?

My measure for shipping charges is 

Shipping Charges = sum('Charge Summary'[Total Amt])

Any help is appreciated.  I put it in Excel to show the sum from the subtotals.

[Anonymous]

Hi @jimrosser ，

The sum of 1296.46, 55343.92, and 240078.06 does indeed equal 296718.47. Could you kindly review the calculation process for the figure 293437.16?

Best Regards,

Bof

[Ashish_Mathur]

Hi,

Share the download link of the PBI file and show the problem there clearly.

[ryan_mayu · Accepted solution]

maybe you can try 

=sumx(values(category), shipping charges)

[jimrosser]

Thank you very much your sumx was spot on 🙂

[ryan_mayu]

you are welcome