Forum Discussion

SinaA's avatar
SinaA
Frequent Visitor
3 years ago

Ranking System Error

I have a question regarding ranking salespeople based on their total sales across different cities using DAX. I'm aiming to have a consistent ranking for each salesperson, regardless of any filters a...
jiaopengzi's avatar
jiaopengzi
Frequent Visitor
3 years ago

You can use the new function: RANK
to see if it is what you want, the first picture is unfiltered, and the second picture is added with a slicer filter

 

_RANK = RANK ( DENSE, ALL ( Sales ), ORDERBY ( [Sales], DESC ) )

 

 

 

 

 

  • SinaA's avatar
    SinaA
    Frequent Visitor
    3 years ago

    I appreciate your suggestion. However, I would like to rank salespeople (A, B,....) based on their total sales. Additionally, I would like to rank them when filtering for City or Category. 

    Thanks!

    • jiaopengzi's avatar
      jiaopengzi
      Frequent Visitor
      3 years ago

      You can simulate a result. I don't quite understand what you mean.