Ranking an item as #1 and then the rest high to low?

[Lanabanana]

Hi everyone,

I have 10 cities in Canada that I would like to rank alongside the country.

But the rank I would like to do is have Canada show up first in a bar chart and then all the other geographies show up in order of highest movement to lowest movement. And, I would like this to update on its own as new numbers come in (as opposed to having to rank on my own each time)

So, in a table it would like like:

Canada	+2%
Vancouver	+7%
Toronto	+6.5%
Halifax	+5%
Winnipeg	+3.5%
Fort McMurray	+1%

I'm not sure where to begin with a Dax formula.

Thank you!

[az38]

Hi @Lanabanana 

create a calculated column

Rank = if('Table'[ColumnRegion]="Canada",1,1+Rankx('Table','Table'[ColumnPercentage],,DESC))

then sort your visual by this column

do not hesitate to give a kudo to useful posts and mark solutions as solution