rankx is not working on negative numbers especially for measures

[Pallavi]

I applied rankx method for the values that are outcome of a measure which has positive and negative values that doesn't give a proper ranking.

Balance            rank

100                    1

90                      2

70                      3

50                      4

20                      5

-10                    8                   -> It should give a rank 6

-20                    9                   ->  rank 7

Any Suggestions?

[Greg_Deckler]

Can you share your formula?

Because the following two measures work for me:

MyBalance = SUM(Balances[Balance])

Rank = RANKX(ALL(Balances),[Balance],[MyBalance])

[Pallavi]

It involves a loop of measures

RankVolBalByBorough = IF(HASONEVALUE(HFSV_Tracker[Borough]),RANKX(ALLSELECTED(HFSV_Tracker[Borough]),[Selected MeasureVolBal],,,Dense)
)

Selected MeasureVolBal = IF(ISFILTERED(HFSV_Tracker[Borough]), [aYTDBorBalanceVol],[aYTDCmdBalanceVol])

aYTDBorBalanceVol = sum(HFSV_Tracker[P1_Visit])-sum(HFSV_Tracker[VolumeTargetYTD])

aYTDCmdBalanceVol = sum(HFSV_Tracker[P1_Visit])-sum(HFSV_Tracker[RegTargetYTD]) 

Based on the selection, it picks up different measure and that measure is passed to Rankx method.