Calculating a running total from a measure

[HFoy]

Hi All,

I am trying to create a running total from a measure using this formula: 

runningtotal = SUMX(FILTER(ALLSELECTED('Calendar'[MonthYear]), 'Calendar'[MonthYear] <= MAX('Calendar'[MonthYear])),[fc_FB_Change])

The running total is just mirroring the results for [fc_FB_change] as shown in the picture below 

Can anyone help solve this please? 

fc_FB_change is a mesaure that calculates the difference between two other measures.

[v-frfei-msft · Accepted solution]

Hi @HFoy ,

To update the measure should work.

runningtotal = SUMX(FILTER(ALLSELECTED('Calendar'),'Calendar'[Date]<=MAX('Calendar'[Date])),'Table1'[fc_FB_Change])

Regards,

Frank