Forum Discussion
Anonymous
8 years agoNot applicable
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())
- Anonymous8 years ago
Try this
rank := IF([Pacote com Desvio] <> BLANK() ; RANKX(ALL(Pacotes[PACOTE]);[Saldo Desvio]);BLANK())
1 Reply
- AnonymousNot applicable
Try this
rank := IF([Pacote com Desvio] <> BLANK() ; RANKX(ALL(Pacotes[PACOTE]);[Saldo Desvio]);BLANK())