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 🫡👍

Daniel29195's avatar
Daniel29195
Icon for Community Champion rankCommunity Champion
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 🫡👍