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)

     

     

amitchandak's avatar
amitchandak
Super User
6 years ago

In case you take all


Rank = RANKX(all(Sheet1[Client]),CALCULATE(SUM(Sheet1[Sales])),,DESC,Dense)

 

Rank will change with another field you add and give a ranking of the client inside that group.

What is expected outcome

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi

     

    I am just trying to understand why Sales Rank = RANKX(ALL(Sales),[Total Sales]) doesn't work

    Can I not just take the entire sales table?

     

    If I wanted to group by sector, I need to write another DAX formula like: Sales Rank = RANKX(ALL(Sales[Sector]),[Total Sales])