Calculating how many orders needed to surpass the highest salesman by percentage of quota

[ccmiller10]

I'm ranking the salesman by who has the best percentage of quota met. So for example, if Salesman A had a target of 8 orders for the year but they sold 24 than they'd have met 300% of their goal. My request is how to get how many more orders would the other salesman need in order to surpass the 300%. For example, Salesman B had a different target of 6 orders but got 11 sales so far which would be 183%, how many more orders would they need to get to or surpass the leader who has 300%?

I was thinking of doing a measure with variables where I'd calculate the max of the percentage of quota first and then I wasn't sure how to calculate the rest since their target of orders could differ between each salesman.

Thanks for any help!

[jdbuchanan71 · Accepted solution]

@ccmiller10 

Give this a try.

Order to reach max = 
VAR _TopPct = CALCULATE( MAXX ( VALUES ( 'table'[sales rep] ), [Percent of Taget Quota] ), ALL ( 'Table'[Sales Rep] ) )
VAR _TotalOrders = _TopPct * [Quota]
VAR _Remaining = _TotalOrders - [Order Count]
RETURN _Remaining

[ccmiller10]

This worked for me! Thank you so much for the help!