Forum Discussion
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...
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 NathaniDid I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)
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)