Calculated Rank does not always appear correctly

I am having an issue where I have a list of client names and their revenues.  My step 1 rank formula works properly which ranks all clients, but the 2nd step of the formula which is mean to return the rank for one specific client; however, it is returning a different rank number.  Goal of the 2nd step formula is to drop it into a table and see that specific clients rank across different product names listed in column 1     

Rank Formula 1 = RANKX(ALL(table[client name]),[revenue])   Note:  [revenue] = sum(table[revenue])

Rank formula 2 = IF([Focus client revenue] = 0,0,Calculate([rank formula 1],table[client name]="Client X"))

Rank formula 1 returns 4 as the rank which is accurate.  Rank formula 2 returns 5 for the focus client and 0 for all other clients.  Focus client should return a rank of 4.

Thank You!