Forum Discussion
Solved
Cumulative total adding previous total twice
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
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.
| 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
Can i get a measure for above requirement
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.