Calculated Rank does not always appear correctly

[Anonymous]

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!

[edhans]

You are going to have to post some data for most of us to really help, and perhaps a screenshot of your model for the relevant tables. See links below on how to post data.

How to get good help fast. Help us help you.
How to Get Your Question Answered Quickly
How to provide sample data in the Power BI Forum