Running Total of Running Total in DAX

[saglamtimur]

Hi,
I need a metric which calculates "Running Total of Running Total" like

Calculating running total is fine, but I could not figured it out how to calculate "Running Total of Running Total"
Thanks in advance.

 

[Kazlik]

Give this a try

Running Total:=CALCULATE(SUM(Sheet1[actual]),FILTER(ALL(Sheet1),Sheet1[Month] <= MAX(Sheet1[Month])))

Running Total of running total:=CALCULATE(SUMX(Sheet1,[Running Total]),FILTER(ALL(Sheet1),Sheet1[Month] <= MAX(Sheet1[Month])))

 

[saglamtimur]

Thanks a lot. It did the trick.