Problem using RANKX to rank column

[jshatila]

Hi All - I have a ranking table with a column that needs to be ranked and the associated rankings. The ranks were made in the underlying SQL of the view. I am trying to replicate the rank column from the view by using the RANKX formula but am getting some funny results. OverallRank is the column that was calcualted in the view and I am trying to replicate in the _NewRank column. Starting at Rank 124, there is a tie. I want the next value after the two tied values to be 126, but instead my column (_NewRank) is returning 125.

Here is the formula for _NewRank:

_NewRank = 
RANKX(
ALLSELECTED(RestaurantRanks[OverallRankingTotal]),
(RestaurantRanks[OverallRankingTotal]),,,Skip)

[HotChilli]

Is this a calculated column? If so, I don't think you want ALLSELECTED in there.  A simpler formula will work. This is the form

_NewRank2 = 
    RANKX(Table1, Table1[amount],,,Skip)