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 Name Number 1 Number 2 Number 3 A 50 46 89 A 80 56 87...
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