Forum Discussion
olimilo
Post Prodigy
8 years agoRANKX 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...
- 8 years ago
Hi olimilo
A tiny change in your formula is needed :smileywink:
Rank = RANKX ( ALLSELECTED ( Violations[Violation] ), [# of Violations],, DESC, DENSE )
Zubair_Muhammad
Community Champion
8 years agoHi olimilo
A tiny change in your formula is needed :smileywink:
Rank = RANKX ( ALLSELECTED ( Violations[Violation] ), [# of Violations],, DESC, DENSE )
- Zubair_Muhammad8 years ago
Community Champion