Measures work fine but the totals are all wrong

[Anonymous]

Hi Experts

I have a table as below, where the measures work well on their own but the totals are wrong in different ways.

After checking relevant posts here I'm sure that there must be something wrong with my coding below, but indeed don't know how to modify it, limited by my coding capability.  Thanks for your help in advance!

Measures details:

Reserve@GC = CALCULATE(SUM(TotalReserve[Total Value (GC)]),FILTER(TotalReserve,TotalReserve[Type]="Reserve"))

Reserve@GC-1 = CALCULATE(SUM(TotalReserve[Total Value (GC)]),PREVIOUSMONTH('TIME'[MonthDate]),TotalReserve[Type]="Reserve")

Scrapped@GC = CALCULATE(SUM(TotalReserve[Total Value (GC)]),FILTER(TotalReserve,TotalReserve[Type]="Scrap"))

P&L@GC = [Reserve@GC]-[Scrapped@GC]-[Reserve@GC-1]

Raw Table

[amitchandak · Accepted solution]

@Anonymous , Try a measure like

sumx(values(Table[Month Year]),[Reserve@GC]-[Scrapped@GC]-[Reserve@GC-1])

[Anonymous]

Thanks Amit like always. 

The one with your new measure now looks good.

But the highlighted column still return the value of the top row. I guess a SUMX shall fix it too, but tried couple of times and see all failed.

The details of this measure
Reserve@GC-1 = CALCULATE(SUM(TotalReserve[Total Value (GC)]),PREVIOUSMONTH('TIME'[MonthDate]),TotalReserve[Type]="Reserve")