Wrong total from generated row subtotals

[Blooper]

I've been having this issue where I have a measure to get a projection total for some items and the values themselves are fine. The main issue is the auto-generated row subtotal that Power BI provides is different than the total that should be occuring. For reference, the projection is based on weekly totals. So every week we have a different projection and we ignore the rest of the totals. This has already been done by the measure. I exported the data from the table out to excel and manually found the sum of the weeks projection which was the right amount. Is this something that can be changed for the settings in the row subtotals or is this an issue with the measure that Power BI doesn't understand. I will provide screenshots for examples.

Column in Question:
 This is what the column for the projection looks. All row values are accurate except for the row subtotal at the bottom.

The correct Total
This is the manually summed total based on the column values in the previous screenshot.

[Ashish_Mathur · Accepted solution]

Hi,

That can be corrected with the SUMX() measure.  To receive further help, share the download link of the PBI file and show the problem there clearly.

[Blooper]

This fixed the issue, thank you for the assistance!

[lbendlin]

Measures are about context. In a matrix visual a measure is computed four times, for the cells, the column totals, the row totals and the grand total.  You can choose to have four different formulas, or you can (and should) "think like the Grand Total"  and make your measure work for all other contexts as well.