Calculate cumulative sum for decimal numbers

[Deepan]

I have a table with set of integer IDs and another column called improvement which is a decimal column. I am trying to create a table visual which shows ID, Improvement and the Cumulative Improvement which is the total of previous and current improvement values. To make it clear I have an image below.  

Cumulative Improvement is the  column I want to show in my table visual. As you can see in the image it is the sum of the improvement of the current record and the cumalative improvement of the previous record. 

I created a measure to achive this.

But what I get is the same value as Improvement column. What am I doing wrong here?

[v-caliao-msft]

@Deepan,

It seems your formula is correct. I can use this DAX expression to get expected result.

In your scenario, could you please share your PBIX file, so that we can make further analysis.

Regards,

Charlie Liao

[Anonymous · Accepted solution]

Very close.  First thing, you need to do this as a column rather than a measure.  Then you can use this code:

Cumulative Improvement = CALCULATE(
	SUM(Sheet1[Improvement]),
	all(Sheet1),
	Sheet1[ID] <= EARLIER(Sheet1[ID])
)