Forum Discussion
olimilo
Post Prodigy
Post ProdigyRANKX 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...
Hi olimilo
A tiny change in your formula is needed :smileywink:
Rank = RANKX ( ALLSELECTED ( Violations[Violation] ), [# of Violations],, DESC, DENSE )
mattbrice
Solution Sage
Solution SagePlease try replacing your ALLSELECTED statement with this
ALLSELECTED('Violations'[Violation] )
olimiloPost Prodigy
Post ProdigyThanks for the help everyone! Although I find it weird that I had to indicate the column I'm going to be working on. I thought that using it on the measure would be enough.