Forum Discussion
RANKX Assigning Duplicate Values
I am having trouble using the RANKX function. I have two tables. One is a table with inventory values that contains the measure INV $ (The measure is just a sum of the inventory $ column). The other ...
Thanks for the reply! I tried it, but unfortunately that did not work. I ended up with larger chunks of duplicate ranks. I should also mention I do have other filters on the item table in the report that I need the rank to take into consideration, so I am not sure if ALL is what I need or not. I am just starting to learn more complicated DAX though, so sometimes I get confused.
Hi rhouse,
Could you post your table structures(including table relationships) with some sample data, so that we can help further investigate on this issue? It's better that you can also share a sample pbix file if possible. You can upload it to OneDrive or Dropbox and post the link here. Do mask sensitive data before uploading. :smileyhappy:
Regards