Forum Discussion
Trouble with RANKX and Mutliple Columns
StevenTeglman , Rank measure is pretty sensitive to row context. So the addition of field name to the table means all vendor inside the field name
example
City Rank = RANKX(all(Geography[City]),[Sales]) // this does not work with city id, all ranks are 1
City and ID Rank = RANKX(all(Geography[City],Geography[City Id]),[Sales]) // work with city id
Geography Rank = RANKX(all(Geography),[Sales])// work with city id lowest level in table
For Rank Refer these links
https://radacad.com/how-to-use-rankx-in-dax-part-2-of-3-calculated-measures
https://radacad.com/how-to-use-rankx-in-dax-part-1-of-3-calculated-columns
https://radacad.com/how-to-use-rankx-in-dax-part-3-of-3-the-finale
https://community.powerbi.com/t5/Community-Blog/Dynamic-TopN-made-easy-with-What-If-Parameter/ba-p/367415
Hi amitchandak
Thank you for your response. I tried to implement what you said, yet I'm not sure it worked the way it's supposed to.
I wasn't expecting to need more than 18 gigs of ram to run DAX Measures 😅
The EX table has 1.5 million rows, but I still don't think that should happen?
Anyways, I think I'm just going to settle for using a static rank for my Vendors, instead of a measure. It's not exactly what I want, but it'll have to do.
You might consider providing your dummy pbix that would be helpful for us to investigate it further.
You can upload it to the onedrive for business and share the link here. please don't forget to disclose the expected results and remove the confidential info.
