Forum Discussion

Truelearner's avatar
Truelearner
Helper III
6 years ago
Solved

Rank in columns

Cat Emp Total Sales Emp Individual Rank Emp Deprt Wise Rank Depart Rank A 1 10 1 1 1 B 2 20 2 1 1 C 3 30 3 2 2 A 4 40 4 2 2 A 5 50 5 3 2 B 6 60 6...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    Hi Truelearner ,

     

     

     

     

    Create 3 Calculated Columns

     

    EMP IND RANK = RANKX('Table','Table'[Total Sales],,ASC,Dense)
     
    EMP DEPT RANK = RANKX(FILTER('Table','Table'[Cat] = EARLIER('Table'[Cat])),'Table'[Total Sales],,ASC,Dense)
     
    DEPT RANK = RANKX(ALL('Table'[Cat]),CALCULATE(SUM('Table'[Total Sales]),ALLEXCEPT('Table','Table'[Cat])))
     

    Regards,
    Harsh Nathani

    Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)

amitchandak's avatar
amitchandak
Super User
6 years ago

Truelearner , I do not see a department in data. But looking at rank have a column like this

Dep Total Sales =
SUMX(
FILTER(
'Table',
'Table'[Depart]=EARLIER('Table'[Depart])
),
'Table'[Total Sales ]
)

 

And create a Rank on it

RankX(all('Table'),[Dep Total Sales])

 

Do changes as per need