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!
