rankx cannot compare text with numbers- calculate lowest 10 customers

[snifer]

i got my table with column company (text) and column revenue

i want calculate 10 lowest performer

 i trying something like that

LOWEST 10 =
var customerrank = RANKX(MASTER_INVOICE;all(MASTER_INVOICE[Company]);[TOTALREVEUEINVOICE];ASC)
return
if (customerrank <= 10;[TOTALREVEUEINVOICE]; blank())

but i got an error on rankx doesn't support compare the text with typer numbers. ( i tried with format and value  but nothing)

how i could fix this? or other way to calculate lowest customers?

[az38 · Accepted solution]

Hi @snifer 

try to take 10 in quotas, like:

return
if (customerrank <= "10";[TOTALREVEUEINVOICE]; blank())

do not hesitate to give a kudo to useful posts and mark solutions as solution