RANKX Ignore Number Less Than Zero

[Anonymous]

Hi, I need to create a Pareto Chart.

But when I add the RANKX measure, it takes the blank values of another formula.

Measures:

Pacote com Desvio:= IF(CALCULATE([Valor Realizado]-[Valor Orcamentos]) <= 0 ; BLANK() ; CALCULATE([Valor Realizado]-[Valor Orcamentos]))

Saldo Desvio:= CALCULATE([Valor Realizado]-[Valor Orcamentos])

rank := IF([Pacote com Desvio] >= 0 ; RANKX(ALL(Pacotes[PACOTE]);[Saldo Desvio]);BLANK())

[Anonymous · Accepted solution]

Try this

rank := IF([Pacote com Desvio] <> BLANK() ; RANKX(ALL(Pacotes[PACOTE]);[Saldo Desvio]);BLANK())