Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

RANKX - Ranking Total Sales

Hi All,   I have been reading a bit on DAX and trying to work out how the RANKX formula works.   I have the below list of data and trying to rank it by sales. My formula is Sales Rank = RANKX(ALL...
Need Help
  • v-frfei-msft's avatar
    v-frfei-msft
    6 years ago

    Hi Anonymous ,

     

    Please update your formula as below.

    Measure = RANKX(ALL(Sales[Client]),[Total sales],,DESC,Dense)

     

     

v-frfei-msft's avatar
v-frfei-msft
Community Support
6 years ago

Hi Anonymous ,

 

Please update your formula as below.

Measure = RANKX(ALL(Sales[Client]),[Total sales],,DESC,Dense)

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Thanks for your help. If I want to rank total sales by sector, I need to write another DAX formula as below?

    Measure = RANKX(ALL(Sales[Sector]),[Total sales],,DESC,Dense)