Forum Discussion

Ryanb2412's avatar
Ryanb2412
Icon for Helper I rankHelper I
6 years ago
Solved

Ranking within a group

Hello,  I am trying to rank employees against each other within the same market they serve.  I am currently unable to get anything to work correctly besides comparing all employees against one anothe...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    Hi Ryanb2412 ,

     

     

    Try a measure

     

    RankEmployee = RANKX(FILTER(ALL('Table'[Market], 'Table'[Employee]),'Table'[Market] = MAX('Table'[Market])),CALCULATE(SUM('Table'[Total Achievement])))
     
     
     
     
     

    Regards,
    Harsh Nathani

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

GaloyanTelman's avatar
GaloyanTelman
Frequent Visitor
3 years ago

Rank By Groups

RANKX ( ALL ( Table[Employee] ),
    CALCULATE ( SUM ( Table[Total Achivment] ),
        ALLEXCEPT (
            Table,
            Table[Employee],
            Table[Market]
        ) ),
    ,
    DESC
)