Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

RANKX Ignore Number Less Than Zero

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's avatar
    Anonymous
    8 years ago

    Try this

     

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

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable

    Try this

     

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