cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Anonymous
Not 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.

 

pareto.PNG

 

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())

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Solution Sage
Solution Sage

Try this

 

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

View solution in original post

1 REPLY 1
Highlighted
Solution Sage
Solution Sage

Try this

 

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

View solution in original post

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Community Conference

Microsoft Power Platform Communities

Check out the Winners!

secondImage

Create an end-to-end data and analytics solution

Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.

Top Solution Authors
Top Kudoed Authors