DAX Rankx function returning only 1

[ViktorT]

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:

Diagram viewOrders tableProduct table

I have constructed measurements as follows:

     Total order value:=sumx(Orders;Orders[Qty]*RELATED(Products[Price]))

     RankOrder:=rankx(All(Orders);[Total order value])      <= is working

     RankProd:=rankx(All(Products);[Total order value])    <= is not working

I tested the formulas in power pivot to present it in a pivot table as per below. As you can see, the rank on items/products is not working properly. Only returning rank 1 for all. I assume this have something to do with the relationships or something, but cannot find out how to solve it.

Result

Any insights would be helpful. Thanks in advance.

best regards

Viktor

[AlB · Accepted solution]

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  

[ViktorT]

@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