Forum Discussion

ViktorT's avatar
ViktorT
Frequent Visitor
6 years ago
Solved

DAX Rankx function returning only 1

Hi   I have encountered some problems with the rankx function. I will try to explain it in as much detail as possible.   Two tables; orders & products:   I have constructed measur...
  • AlB's avatar
    AlB
    6 years ago

    Hi ViktorT 

    In you pivot table on the right, place Products[ItemID] on the rows instead of Orders[ItemID]

     

    Please mark the question solved when done and consider giving kudos if posts are helpful.

    Cheers  Datanaut

     

AlB's avatar
AlB
Community Champion
6 years ago

Hi ViktorT 

In you pivot table on the right, place Products[ItemID] on the rows instead of Orders[ItemID]

 

Please mark the question solved when done and consider giving kudos if posts are helpful.

Cheers  Datanaut

 

ViktorT's avatar
ViktorT
Frequent Visitor
6 years ago

AlBthanks alot for your quick reply. Such an irritatingly simple solution =)

I guess the conclusion is to take care of from which table the ranking value originates from when presenting the data, regardless which table you put the measurement.

cheers