Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Dynamic ranking by sorted column

Hello!

 

Let's say I've such table visual which is ranked by Volumes according formula Rank = RANKX(ALL(Organisations[Organisation]);[Volumes];;DESC;Dense)

 

For example I want to sort Revenue column from largest to smallest value and rank it accordingly. How can I do it?

 

p.s. Volumes/Revenue/CM are measures.

 

RankOrganisationVolumesRevenueCM
1Company13443.020 €218 €
2Company3421.245 €320 €
3Company11363.193 €111 €
4Company6303.574 €474 €
5Company10254.685 €242 €
6Company8231.161 €424 €
7Company14222.220 €166 €
8Company4212.089 €162 €
9Company9212.461 €289 €
10Company2193.597 €308 €
11Company1134.468 €358 €
12Company5131.199 €391 €
13Company12134.454 €263 €
14Company721.883 €130 €

2 Replies