Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 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.
Any insights would be helpful. Thanks in advance.
best regards
Viktor
Solved! Go to 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
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
@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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
47 | |
24 | |
20 | |
15 | |
13 |
User | Count |
---|---|
51 | |
46 | |
39 | |
19 | |
19 |