Forum Discussion

StuartSmith's avatar
StuartSmith
Icon for Power Participant rankPower Participant
2 years ago
Solved

Cant get RANK to work correctly.

I have a table similar to ... and trying to create a calculated column Ranked by ID and AbsenceDate   ID   AbsenceDate   Name   Required Rank   RANKX   RANK 1   01/01/2024   Joh...
Need Help
  • Daniel29195's avatar
    Daniel29195
    2 years ago

    StuartSmith 

     

    Measure 3 =
    var dataource =  
    CALCULATETABLE(
        SUMMARIZE(
            table3,
            table3[ID],table3[Name],table3[AbsenceDate]),

            ALLEXCEPT(table3,table3[ID])
    )

    var result =
    RANKX(
        dataource,
        calculate(max(table3[AbsenceDate])),
        ,
        DESC,
        Dense
    )

    return result



     

     

     

    If my response has successfully addressed your issue kindly consider marking it as the accepted solution! This will help others find it quickly. Dont forget to hit that  thumbs up button 🫡👍

StuartSmith's avatar
StuartSmith
Icon for Power Participant rankPower Participant
2 years ago

Adjusted the above and this worked. 🙂

 

RANK =
VAR _t1 = 'Table: Absence Master List'[Absence Recording ID]
Return
RANKX(FILTER('Table: Absence Master List', 'Table: Absence Master List'[Absence Recording ID] = _t1),'Table: Absence Master List'[Absence Day],,ASC)