Sorting based on count measurement with a related table

[amiller5]

Hi - 

I have 2 tables that have a many to one relationship - it essentially categorizes multiple "case reasons" into a more condensed naming.

Then I have a measure that is the count of fields.

I want to sort all the tables by volume, descending but it defaults to alphabetical. I cannot select the ticket category and sort column because the measure count that I want to sort by is not in the same table. Is there a solution?

[amitchandak · Accepted solution]

@amiller5 , every visual you have 3 dots, from that you can choose a column to sort

How to Create Sort Column and Solve Related Errors:
https://www.youtube.com/watch?v=KK1zu4MBb-c