cancel
Showing results for
Did you mean:
Member

## Accumulated value based on ranking DAX

Hi,

I'm looking for a dax formula to show the value accumulated based on it's ranking

Prod A = 3 (euro, dollar, kg, ..)

Prod B = 1

Prod C = 7

Ranking of products:

Prod A = rank 2

Prod B = rank 3

Proc C = rank 1

Now I want to present a graph:

X axis = rank 1, rank 2, rank 3

Y axis = value 7, 10, 11

I found the dax for the rank: RANKX(all(table[prod]);[value]).

Thanks for your support.

Johan

1 ACCEPTED SOLUTION

Accepted Solutions
MVP

## Re: Accumulated value based on ranking DAX

Hi @Johan,

@Greg_Deckler is right.  Perhaps try adding the following calculated columns to your table

`Rank = CALCULATE(COUNTROWS('Table1'),ALL('Table1'),'Table1'[Value] > EARLIER('Table1'[Value]))+1`
`Cumulative = CALCULATE(SUM('Table1'[Value]),ALL('Table1'),'Table1'[Rank]<= EARLIER('Table1'[Rank]))`

You can then plot these two columns on the axis of a scatter as follows

Proud to be a Datanaut!

4 REPLIES 4
Super User

## Re: Accumulated value based on ranking DAX

Perhaps a cumulative measure that does a SUM of any lower RANK?

### I have book! Learn Power BI from Packt

Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

Member

## Re: Accumulated value based on ranking DAX

Thanks for you comment, would you have an example of how to do that?

MVP

## Re: Accumulated value based on ranking DAX

Hi @Johan,

@Greg_Deckler is right.  Perhaps try adding the following calculated columns to your table

`Rank = CALCULATE(COUNTROWS('Table1'),ALL('Table1'),'Table1'[Value] > EARLIER('Table1'[Value]))+1`
`Cumulative = CALCULATE(SUM('Table1'[Value]),ALL('Table1'),'Table1'[Rank]<= EARLIER('Table1'[Rank]))`

You can then plot these two columns on the axis of a scatter as follows

Proud to be a Datanaut!

Member

## Re: Accumulated value based on ranking DAX

Thanks. That worked.

Announcements

Kudos to you if you earned one of these! Check your inbox for a notification.

#### Microsoft Implementation for Communities Wins Award

Learn about the award-winning innovation that was implemented across Microsoft’s Business Applications Communities.

#### Power Platform World Tour

Find out where you can attend!

Top Solution Authors
Top Kudoed Authors (Last 30 Days)
Users online (3,601)