DAX Rankx function returning only 1

Question

Hi&nbsp;I have encountered some problems with the rankx function. I will try to explain it in as much detail as possible.&nbsp;Two tables; orders &amp; products:&nbsp;Diagram viewOrders tableProduct tableI have constructed measurements as follows:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Total order value:=sumx(Orders;Orders[Qty]*RELATED(Products[Price]))&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; RankOrder:=rankx(All(Orders);[Total order value])&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;= is working&nbsp;&nbsp;&nbsp;&nbsp; RankProd:=rankx(All(Products);[Total order value])&nbsp;&nbsp;&nbsp; &lt;= is not working&nbsp;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.ResultAny insights would be helpful. Thanks in advance.best regardsViktor&nbsp;

alb · Accepted Answer

Hi&nbsp;ViktorT&nbsp;
In you pivot table on the right, place Products[ItemID] on the rows instead of Orders[ItemID]
&nbsp;
Please mark the question solved when done and consider giving kudos if posts are helpful.
Cheers&nbsp;&nbsp;
&nbsp;

Forum Discussion

DAX Rankx function returning only 1

2 Replies

Related content

RANK and RANKX DAX function

Using the RANKX Function...return 1

RANKX DENSE functionality

RANKX Formula Returning Duplicate Ranks

Why rankx function shows duplicated rank?