Running total bassed on Ranking

[Yonah]

Hi,
I want to calculate a runing total based on ranking, without a date.

That's the very simplified data I'm using

Articel Name	Number 1	Number 2	Number 3
A	50	46	89
A	80	56	874
A	90	55	7
B	50	415	4
B	746	45	5
C	4	45	89
C	54	45	5

Thats the first Dax, I'm using.

Value for Ranking = Sum(Tabelle1[Number 1])*Sum(Tabelle1[Number 2])*Sum(Tabelle1[Number 3])

And thats the Dax I'm using for the Ranking.

Ranking = 
RANKX(
    CALCULATETABLE(SUMMARIZE('Tabelle1','Tabelle1'[Articel Name]),ALL(Tabelle1[Articel Name])),[Value for Ranking],,DESC)

So thats my Table locks like this.

 Now I want to calculate the runing total. And I coulden figuer it out, how to do it, so any help would be appreciated.
Thanks


Thats the Link to my PowerBI-File:
https://clptradinggmbh699-my.sharepoint.com/:u:/g/personal/aust_clptradinggmbh699_onmicrosoft_com/EY... 

[BeaBF]

@Yonah Hi! Try with:
RunningTotal =
CALCULATE(
SUMX(
FILTER(
ALL('Tabelle1'),
'Tabelle1'[Ranking] >= EARLIER('Tabelle1'[Ranking])
&& 'Tabelle1'[Articel Name] = EARLIER('Tabelle1'[Articel Name])
),
'Tabelle1'[Value for Ranking]
)
)

BBF

[Yonah]

@BeaBF The Problem is, Ranking is a Measuere not a Colum with in the Table. 

[BeaBF]

@Yonah ok, so:
RunningTotal =
CALCULATE(
SUMX(
FILTER(
ALL('Tabelle1'),
CALCULATE([Ranking]) >= VALUES('Tabelle1'[Ranking])
&& 'Tabelle1'[Articel Name] = VALUES('Tabelle1'[Articel Name])
),
[Value for Ranking]
)
)

BBF