Simple ranking does not work

[SebSchoon1]

Hi guys,

I have mail adresses from a specific table (dimension table)

i have sales total from fact table

and i'd like to rank the sales by mail address.

here is what i get with 

Rank Ventes par client = rankx(ALLSELECTED('TIERS'),[Montants tickets])

Why is there Two 12 rank even if data is totaly different?

Kind regards

[Shaurya]

Hi @SebSchoon1,

Try:

Rank = RANKX(ALL('Tiers'),'Tiers'[Montants Tickets],,SKIP)

Works for you? Mark this post as a solution if it does!
Consider taking a look at my blog: Forecast Period - Previous Forecasts

[SebSchoon1]

Hi @Shaurya 

The  'TIERS'[Montants Tickets]  is in fact a measure which is not part of the Table 'TIERS'

RANKX(ALL('Tiers'),'Tiers'[Montants Tickets],,SKIP)

🙂