Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
Hello. I'm trying to rank the behavior of a number of products over time. It turns out that there are times that the RankX solves the ranking correctly but there are times that it repeats the values and I do not know why it does.
Has anyone faced this problem and could you help me?
This is the DAX of rankx
and this is the picture of the problem
Thanks a lot
Hi,
I am not sure how your Data model looks like, but please try the below whether it suits your requirement.
Ranking2 =
RANKX (
FILTER (
SUMMARIZE (
ALL ( 'Data (2)' ),
'Data (2)'[REG. CORPORATION],
'CalendarTable'[Month]
),
'CalendarTable'[Month] = MAX ( 'CalendarTable'[Month] )
),
CALCULATE ( SUM ( 'Data (2)'[MXN] ) ),
,
DESC,
SKIP
)
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
Thank you very much, if it works, only there is something strange that is happening with the RankX function, when I apply it to all the data it works well but when I apply a company filter the function no longer works well until I select several companies.
In the image we can see that Company 170 in the month of July has the10th position when all the companies are selected.
But when you select that company only, the ranking changes to 1 and is corrected back to 10 when more than one company is selected.
Hopefully you can help me find what I am doing wrong with the filters, I have been trying for hours and I can not find the problem
Thanks a lot
Hi,
Thank you for your feedback.
I am not sure how your data model looks like, but I think you can try to replace ALL in the measure with ALLSELECTED whether it suits your requirement.
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
Hello. The Allselect does not help solve the problem.
Add the link with my data model in case you can help me check that I'm doing wrong.
Thanks a lot
https://drive.google.com/drive/folders/1Ii5y_4LY-rihNpbCqMnkN7WXOF__Kmm2?usp=sharing
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
87 | |
83 | |
82 | |
65 | |
49 |
User | Count |
---|---|
135 | |
111 | |
100 | |
65 | |
62 |