Forum Discussion
Simple ranking does not work
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 Ran...
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
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)🙂
