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)

Truelearner's avatar
Truelearner
Helper III
6 years ago

amitchandak  Thanks for sharing those links , with the help of them i am able to acheive first two requirements but not able to figureout how to write dax for third requirment (Overall department rank) , can you please take a look ?