Rankx with other values in table

[DennisA]

Hello ,

I asked help on this topic before and have come a long way but still am stuck. i have put this aside for a while but wanted to continuenow.
I have a table with Ordernumber, partnumber, some other values. I created a measure indicating the results of that specific order.
I then created a RanxX to see what orders are the best ones .

RANKX(ALLSELECTED(POResultaten[ProdHeaderOrdNr]), [R_VerschilDraaien],,DESC)

when I make a simple table in a report with the Ordernumber and the rank i see (i filtered to 5) 5 records.

When I also add the column Partcode i get a lot of records all show rank 1

What am I doing wrong??

[DennisA · Accepted solution]

Thank you all, This didn't solve it. I googled furter and got this solutiuon:
 
[Rank Name] :=
IF (
    HASONEVALUE ( Test[Name] ),
    RANKX ( ALL ( Test[Name], Test[Value] ), [Sum Value] )
)
https://www.sqlbi.com/articles/use-of-rankx-in-power-bi-measures/#

[Pragati11]

Hi @DennisA ,

This is because your ranking is based on just POResultaten[ProdHeaderOrdNr] column not on POResultaten[ProdHeaderOrdNr] and [PartCode] column.

Modify your dax to consider both the columns for getiing the Rank calculation.

https://prologika.com/dax-rank-over-two-columns/

https://community.powerbi.com/t5/Desktop/Summarize-and-Rank-by-multiple-columns-and-rows/td-p/330108

[Greg_Deckler]

@DennisA You may find this article helpful with RANKX - https://community.powerbi.com/t5/Quick-Measures-Gallery/To-Bleep-with-RANKX/m-p/1042520#M452