cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Helper II

## 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 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:

3 REPLIES 3
Memorable Member

@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

Helper II

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

Memorable Member

@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

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.