topic Running total bassed on Ranking in DAX Commands and Tips

Running total bassed on Ranking

Yonah — Wed, 06 Dec 2023 10:56:16 GMT

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/EY5d1-g0BO1OoiPJGvv7eQ4BPYB_1o32LEOAdEw0PPbTzQ?e=vaGUkh

Re: Running total bassed on Ranking

BeaBF — Wed, 06 Dec 2023 13:45:58 GMT

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

Re: Running total bassed on Ranking

Yonah — Wed, 06 Dec 2023 14:22:16 GMT

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

Re: Running total bassed on Ranking

BeaBF — Wed, 06 Dec 2023 14:24:42 GMT

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