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/#
