Forum Discussion
RANKX by ID but return Name?
Travis_rh , Not very clear
Try lIke
rankx(allselected(Summary[Company_id], Company[Name]), [overall score],,desc,dense)
refer if needed
https://radacad.com/how-to-use-rankx-in-dax-part-2-of-3-calculated-measures
Power BI Rank Across dimension tables: https://youtu.be/X59qp5gfQoAIf this does not help
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
Super UserTravis_rh , Not very clear
Try lIke
rankx(allselected(Summary[Company_id], Company[Name]), [overall score],,desc,dense)
refer if needed
https://radacad.com/how-to-use-rankx-in-dax-part-2-of-3-calculated-measures
Power BI Rank Across dimension tables: https://youtu.be/X59qp5gfQoA
If this does not help
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
Thank you.
I marked as the solution, but there is a caveat - it only functions if I have the Industry slicer set to a specific value rather than "all."
I forgot to mention in my original post that there are two other slicers on the page, but they were not set to anything. So, perhaps it was a sort of conflict with the ALLSELECTED() not including those other slicers?