Cumulative total adding previous total twice

[vijaykumarj19]

Axis	Actual	Cummulative
a1	5	5	5
a2	10	20	5+5+10
a3	15	50	20+5+10+15
a4	20	100	50+5+10+15+20
a5	25	175	100+5+10+15+20+25

Required cummulative column 

[amitchandak]

@vijaykumarj19 , Try a measure like

calculate(sum(Table[Actual]), filter(allselected(Table), [Axis] < max(Table[Axis]))) + sum(Table[Actual])

[vijaykumarj19]

Current value is summing up with previous cummulative 
But it should be added like below

[v-jingzhang]

Hi @vijaykumarj19 , please try below measures.  Cumulative Total 3 is what you need.

Cumulative Total 1 = CALCULATE(SUM(Tbl2[Value]),FILTER(ALL(Tbl2),Tbl2[Axis]<=MAX(Tbl2[Axis])))

Cumulative Total 2 = CALCULATE(SUMX(VALUES(Tbl2[Axis]),[Cumulative Total 1]),FILTER(ALL(Tbl2),Tbl2[Axis]<=MAX(Tbl2[Axis])))

Cumulative Total 3 = CALCULATE(SUMX(VALUES(Tbl2[Axis]),[Cumulative Total 2]),FILTER(ALL(Tbl2),Tbl2[Axis]<=MAX(Tbl2[Axis])))

 

Kindly let me know if this helps.
Community Support Team _ Jing Zhang
If this post helps, please consider Accept it as the solution to help other members find it.

[vijaykumarj19]

Axis	Value	Output
1	5	5
2	10	20
3	15	50
4	20	100
5	25	175

 Output :-
5 = Val1(5)

20 =output1(5) + Val1(5)+val2(10)

50 = output2(20) + Val1(5)+val2(10)+val3(15)

.

.

Required output field 

[vijaykumarj19]

Can i get a measure for above requirement  

[v-jingzhang · Accepted solution]

@vijaykumarj19 I use below measures to get the output. Put [Total 1] in [Total 2].

Total 1 = SUMX(FILTER(ALL('Tbl3'),'Tbl3'[Axis]<=MAX('Tbl3'[Axis])),'Tbl3'[Value])

Total 2 = SUMX(FILTER(ALL('Tbl3'),'Tbl3'[Axis]<=MAX('Tbl3'[Axis])),[Total 1])

I am struggling to get the output with only one measure but haven't figured it out.