Forum Discussion

NB689's avatar
NB689
Icon for Helper I rankHelper I
4 years ago
Solved

Help with RANKX

I have looked through some other threads and articles online but I can't sort out what my issue is that I'm having with RANKX.   My goal is to have a ranking that ranks by user ID, and will auto up...
  • NB689's avatar
    NB689
    4 years ago

    This took some trial and error, but I ended up solving my issue. One change I am going to make is I would like for the ranking to not duplicate the ranking in the event of a tie and I would like the ranking to update when I filter the data, but other than those changes it looks like this is working.

    Rank X Personal Time = 
RANKX(ALL('Non Overlapping'[User ID]), CALCULATE(SUM('Non Overlapping'[After Hours] ) , ALLEXCEPT('Non Overlapping', 'Non Overlapping'[User ID])),,DESC,Dense)