Forum Discussion

Yonah's avatar
Yonah
Helper II
2 years ago

Running total bassed on Ranking

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

That's the very simplified data I'm using

Articel NameNumber 1Number 2Number 3
A504689
A8056874
A90557
B504154
B746455
C44589
C54455


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 

3 Replies

  • BeaBF's avatar
    BeaBF
    Super User
    2 years ago

    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's avatar
      Yonah
      Helper II
      2 years ago

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

      • BeaBF's avatar
        BeaBF
        Super User
        2 years ago

        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