Forum Discussion

olimilo's avatar
olimilo
Icon for Post Prodigy rankPost Prodigy
8 years ago
Solved

RANKX always returns 1

I've already inspected the other threads with the same dilemma, but most of them are running with SUMs of a numeric column. I'm trying to get the rank of an item through the number of instances it ha...
  • Zubair_Muhammad's avatar
    8 years ago

    Hi olimilo

     

    A tiny change in your formula is needed :smileywink:

     

    Rank =
    RANKX ( ALLSELECTED ( Violations[Violation] ), [# of Violations],, DESC, DENSE )