Cumulative sum/running total does not produce the desired result.

[Dunner2020]

Hi there,

I have a measure that calculates the cumulative sum/running total. The measure looks like:

Cumulative deweight =

SUMX(FILTER('Outages and Interruptions','Outages and Interruptions'[Actual Interruption Start Time (NZST)]<=Max('Outages and Interruptions'[Actual Interruption Start Time (NZST)])),[Deweight Sum])

When I tried to plot in a line graph, it looks like as follow:

 I am not sure where am I making the mistake. Could anyone help me in fixing the issue? Sample file can be download from here

[v-deddai1-msft · Accepted solution]

Hi @Dunner2020 ,

Would you please try the following measure and it will show your expected output:

Cumulative deweight = 
SUMX(FILTER(ALL('Outages and Interruptions'),'Outages and Interruptions'[Actual Interruption Start Time (NZST)]<=Max('Outages and Interruptions'[Actual Interruption Start Time (NZST)])),[Deweight Sum])

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Best Regards,

Dedmon Dai

[parry2k]

@Dunner2020 there is too much going in your pbix file, you should put a sample data in excel and explain what you are looking for.