Forum Discussion

SebSchoon1's avatar
SebSchoon1
Post Patron
3 years ago

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 

 

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

 

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

 

Kind regards

 

Need Help

2 Replies

    • SebSchoon1's avatar
      SebSchoon1
      Post Patron
      3 years ago

      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)

       

       

      🙂