Raking within a group

Thank you Anonymous

Unfortunately I am connected to a complex database and there are a lot of selections through slicers in order to come with this particular graph.

So your solution is giving me the overall rank of the sections and not on that particular selection, so it's not really by school.

What I did is convert the schools to a high value number and add that number to the raking column and have my chart sorted by that.

School_Ranking: School1 = 100000, School2 = 200000
Final_Ranking: School_Ranking + Ranking

And finally sections are ranked correctly according to their schools.

One thing remains is to re-rank these sections from 1 to n instead of that big number under each bar.

Any thoughts?