Forum Discussion
RankX ranks stuff that does not exist
Hello!
I need help with my RANKX-function.
I have a facttable that looks like this:
And my RANKX looks like this:
I want to rank each date depending on OD
But when I create a table with the the Supplier Names instead of the supplierID, I get a table where each supplier is on each date, even though there is only one on each date in the facctable.
Why is this happening and what can I do about it?
Thank you very much for any replies
8 Replies
Anonymous , Try measure like
Rankx(allselected(Table[date],Table[Supplier name]), [Distance from selected %])
If you take any column other one used in rank , then rank will be inside that column
For Rank Refer these links
https://radacad.com/how-to-use-rankx-in-dax-part-2-of-3-calculated-measuresThe problem unfortunately remains. Each [Date] still gets every [SupplierName] even though every date only have one supplier and they are connected via a relationship through [SuppllierID].
Anonymous It likely has something to do with your ranking measure. What is the formula for it? Also, this may help:
