Hierarchy Ranking based on measure

[Anonymous]

Hello,

I have a measure that calculates the days passed since a salesman made his last sale.

I would like to create a ranked bar graph that shows the top/bottom salesmen based on my measure

My hierarchy is branch ->salesman (so if i drill down in a branch, I see the salespeople working there).

I would like my ranking to to find the "worst" salesmen but only from the "worst" branches.

So this is kind of a double/embeded ranking.

Finally, is there a way to add a tiebreaker in the ranking? Because if I have 20 salesmen with the same "days since last sale" then I see them all in the ranked graph. Is there a way to determine which ones I will see instead of all of them with the same "score"?

This is why I thought of the "worst" salesmen but only from the "worst" branches "solution". So it would kind of act as a filter/tiebreaker. 

Is there a better way to do something like this?

Thank you.

[v-deddai1-msft]

Hi @Anonymous ,

I have catch your requirements, but  I don't understand what form you want to use to show your expected output.

Would you please inform us more detailed information( your data and expected output (by OneDrive for Business)) if possible? Then we will help you more correctly.

You can refer to the similar post: https://community.powerbi.com/t5/Desktop/RankX-Tie-Break-Alphabetically/td-p/1011051

Please do mask sensitive data before uploading.

Thanks for your understanding and support.

Best Regards,

Dedmon Dai

[amitchandak]

@Anonymous , refer this blog for Rank tie breaker

https://community.powerbi.com/t5/Community-Blog/Breaking-Ties-in-Rankings-with-RANKX-Using-Multiple-Columns/ba-p/918655

or

https://databear.com/how-to-use-the-dax-rankx-function-in-power-bi/