I'm just looking for a way to break rankx ties alphabetically in DAX based on a secondary column (Such as Category Name) without using an index column. I have a simple table visual displaying the top 10 Categories by the Count of categories. I require rankx to break ties alphabetically based on the category name to display only the top 10 values and no more.
I can break the tie using the random function or based on date, but unfortunately cannot figure out how to break it based on text.
I've investigated many solutions on the web and on this site, but none seem to assist with this specifically.