Sum of a measure in the total column

[Smackcat]

Hi experts

I have the following table:

Week	KPI_A	Measure(KPI_B)	Measure(Dif)
1	10
2	12	10	2
3	14	12	2
4	16	14	2
TOTAL	52	52	0

I've created a measure [KPI_B] that equals the value of [KPI_A] of the previous week. I didn't really care about the total of [KPI_B] (because it's a hidden measure) so for the total I stayed with the sum of [KPI_A], as I can't calculate a previous week.

I'm actually having trouble with measure [Dif], that's the difference between [KPI_A] and [KPI_B]. I want to be able to sum measure [Dif] for week 1 to 4 on Total row, so it change from 0 to 6. 

Week	KPI_A	Measure(KPI_B)	Measure(Dif)
1	10
2	12	10	2
3	14	12	2
4	16	14	2
TOTAL	52	52	6

6: sum of the measure on weeks 1 to 4

Do you think it's possible? Thanks!

[Ahmedx · Accepted solution]

write a new measure like this

Dif fixed = SUMX (VALUES('table'[week]),[Dif])

[Smackcat]

Thanks! I really needed this