Ranking Help

Question

Hi All&nbsp;I'm new to Power BI and i am needing some help&nbsp;on ranking&nbsp;My source data has a list of all the individual sales that have been made throughout the year. I want to be able to rank the sales reps based on the total YTD revenue,&nbsp;My report has a number of slicers to select the team name, sales rep name and product sold - i would like the ranking to update depending on whatever has been selected&nbsp;My data looks something like this:&nbsp;Team&nbsp; &nbsp;Sales Rep&nbsp; &nbsp; &nbsp;Product&nbsp; &nbsp; &nbsp;RevenueA&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Rep 1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;X&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;$100A&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Rep 1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Y &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $50A&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Rep&nbsp;2 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; X&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;$100A&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Rep&nbsp;2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Y&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;$100B&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Rep 1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;X&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;$50B&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Rep 1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Y&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;$75B&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Rep&nbsp;2 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; X&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;$100&nbsp;I need to be able to see the following when a team is selected by the user:&nbsp;&nbsp;Team&nbsp; &nbsp;Sales Rep&nbsp; &nbsp; &nbsp;Revenue&nbsp; &nbsp; &nbsp;RankA&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Rep 1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;$150&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2&nbsp; &nbsp;A&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Rep&nbsp;2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;$200&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1&nbsp;&nbsp;B&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Rep 1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;$125&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1&nbsp; &nbsp;B&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Rep 2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;$100&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2&nbsp;Thanks&nbsp;

liviolanzo · Accepted Answer

You can achieve your results with the below measure. Depending on what you put on the matrix the measure may change&nbsp;=IF&nbsp;(&nbsp;&nbsp;&nbsp;&nbsp;ISFILTERED&nbsp;(&nbsp;Table1[SalesRep]&nbsp;),&nbsp;&nbsp;&nbsp;&nbsp;RANKX&nbsp;(&nbsp;ALLSELECTED&nbsp;(&nbsp;Table1[SalesRep]&nbsp;),&nbsp;[TotRevenue]&nbsp;))&nbsp;where TotRevenue is a Measure =&nbsp;SUM( Table1[Revenue] )&nbsp;&nbsp;

Forum Discussion

Ranking Help

2 Replies

Related content

Duplicate ranking

Ranking KPI card

Rank with conditions

Dynamic Ranking

What are community ranks?