Forum Discussion
RANKX Assigning Same Rank to Different Values
I've been struggling hard with RANKX for a few days now. We are connected to a data model, so we're limited to only measures. I'm trying to create a stack rank that just looks at a revenue ...
I had the same problem. Including Dense at the end of the measure fixed it so it rank sequentially. I think it defaults to skip unless you specify. I'm a Power BI newb, but I hope this helps.
Station Factor Rank = RANKX(ALLSELECTED(StationList[STATION]),[Station Factor],,DESC,Dense)
I have an issue with RANKX giving the same rank to different values, for instance
Value Rank
1 - 4
1 - 3
2 - 3
3 - 2
4 - 1
Not sure how to fix this, but I have been trying to understand it for the last 5 hours. I wish it was easy as excel.
I found a resolution for RANKX assigning a different rank to the same value. I used Round for the [Station Factor] measure to ignore the decimals more than 2 places.
Thanks for that, I was banging my head against the wall!
