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)

     

     

az38's avatar
az38
Community Champion
6 years ago

Hi Anonymous 

how do you get [Total Sales] measure?

 

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

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Total Sales = Sum(SalesTable[Sales])