I believe you can solve your issue by simply using Index.
Create a calc called index
[Index] = Index()
Drop this in your filters, select the dimensions used in your scatter plot (ID and *** for the dogs).
I have attached the update workbook for you to reference.
Select custom sort from the sort order, choose the measure you want it ranked on, choose descending.
DoggoScatterChart.twbx 94.4 KB
Sorry, should have mentioned, edit the Index in your filter and choose "edit table calculation"
Great solution, thank you !