Calculate sum of all previous indexes

[pejczi]

Hello,

Let's say that I have a table like that :

Index   Value

1           90

2           120

3           140

4           150

In the visualisation, I am making a slicer with Indexes (so I can choose from 1 to 4)

What I want to do, is when I select 3, I am calculating the sum of all values below and including 3 (in the example it would be 90+120+140).

Any solutions? I was trying various calculate() + filter() options, but none of them worked correctly.

[JulioGadioli]

I want to collaborate with my code that fetches the remaining value (sum) by the previous index.

Create column

Indice = RANKX(ALL(ParcelaLista_Filtrado),ParcelaLista_Filtrado[Data da Base],, ASC, DENSE )

And 

Create a measure

Valor Anterior =

 IF (SELECTEDVALUE(ParcelaLista_Filtrado[Indice] ) <> 1,

 CALCULATE(SUM(ParcelaLista_Filtrado[Valor restante]),FILTER(all('ParcelaLista_Filtrado'),'ParcelaLista_Filtrado'[Indice]<= MAX('ParcelaLista_Filtrado'[Indice])-1)),

  0

 )

Thanks popov I want to your colaboration, by ALL () and ...<=MAX helped me a lot.

[popov · Accepted solution]

Hello, @pejczi

Please, try this formula:

Cumulative Total =
CALCULATE (
    SUM ( Table[Value] ),
    FILTER ( ALL ( Table[Index] ), Table[Index] <= MAX ( Table[Index] ) )
)

[pejczi]

Thank you, it works after adjusting to my case (some of features stopped working, but I need to adjust relations a little bit, but generally it is okay :-))