Group values in calculated column in one table by static measure derived from another table

[d_brew]

MngAuditsAvgDayRemaining = ROUNDUP([AuditsMonthRemaining]/[MngWorkDaysRemainingMonth], 0)

This measure gives me the the average number of audits needed by each manager for each work day until the end of the month to hit our target goal (i.e. if each of the 7 managers does 11 audits a day over the next 14 work days including today remaining in February, we will hit our goal.

When used in a Card it gives me the expected value (below).

I have a table that contains each employee, ranked incrementally by number of Audits remainging. 

What I need to do is create a calculated column that assigns a manager to each employee by their rank. For example, employees ranked 1-11 would have manager 1's name, 12-22 would have manager 2's name, 23-33 would have manager 3's name, all the way through manager 7 who would be assigned empoyees ranked 67-77. The idea here is to give each manager a daily target of audits to complete so that the indivduals with the highest priority(lowest amount of audits complete this month which results in them having the higher rank) are audited first, and we complete the necessary amount of audits each day to hit our goal by the en of the month. 

The relationships are listed below. What should happen is that the TS_Roster table contains a column where the top 77 ranked employees (as calculated at this very moment) have a managers name assigned to them so that each manager can filter by their name to see who they need to audit today. 

[Anonymous]

@d_brew,

Could you please share dummy data of your tables and post expected result based on the dummy data here?

Regards,
Lydia