Forum Discussion
Helper IRankx with other values in table
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??
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/#
3 Replies
- Greg_Deckler
Community Champion
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
- Pragati11
Super User
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
DennisAThank 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/#
