cancel
Showing results for
Did you mean:

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

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
Impactful Individual

@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.

Impactful Individual

@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

#### Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

#### Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

#### Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors