Forum Discussion
RankX ranks stuff that does not exist
Greg_Deckler
I apoligize for not being clear enough. Will do my best to tackle this in the future. How do I upload my .pbix-file?
1. I have a file but I don't know how to share it.
2. The measure [Distance from OD %] gives a value to each date depending on a slicer, the code looks like this:
Distance from selected OD % =
DIVIDE(
ABS( MAX( PurchaseFacts[OD] ) - SELECTEDVALUE( 'OD Diameter'[OD Diameter] ) ),
MAX(PurchaseFacts[OD])
)This is just a measurement on how far away a date is from a selected value in a slicer.
I want to order these by how large they are.
Ranking OD Differance =
RANKX( ALL(PurchaseFacts[Date]), [Distance from selected OD %] ,, ASC )Nothing Strange this far. It looks like it should
But when I replace SupplierID with SupplerName this happens:
Every date get every supplier.
This is the relationship:
Why is this happening? How can I prevent this?
How Do I upload my pbix-file?
Anonymous Upload your PBIX to OneDrive, Box or any file sharing site and then share a link. Easiest, quickest way.
- Anonymous5 years agoNot applicable
Greg_Deckler
https://drive.google.com/file/d/14KgNeBnTj0dmn7n7KXmZfAqSdpDL4thf/view?usp=sharingUse this together with the schreenshots i provided before.
Thank you very much for helping me