Assignment of rows

Question

Hi&nbsp;I am looking for a formula that checks how many rows have already been assigned to an employee for example, if an employee has more than the a average of the rest of the employees, then flag. I would want the amount of rows that they have been over assigned to be reassigned back to the rest of the employees so everyone has in and around the same amount of rows.&nbsp;&nbsp;Kind regards,Katie&nbsp;

amitchandak · Answer

Anonymous ,
compare these two
&nbsp;
countrows(table)&nbsp; and averageX(summarize(all(table),table[emp],"_1",countrows(Table)),[_1])

v-xicai · Answer

Hi Anonymous&nbsp;,
&nbsp;
You may create measure like DAX below.
&nbsp;
CountFlag= COUNTX(SUMMARIZE(ALLSELECTED(Table1),Table1[employee],"_flag", IF( MAX( Table1[Employee Value])&gt; AVERAGE( Table1[Employee Value]),"flag") ), [_flag] )
&nbsp;
If I misunderstood it, could you please share your sample data and desired output screenshots for further analysis? You can also upload sample pbix to OneDrive&nbsp;and post&nbsp;the link here. Do mask sensitive data before uploading.
&nbsp;
Please read this post to get your answer quickly: How to Get Your Question Answered Quickly
&nbsp;
Best Regards,
Amy&nbsp;
&nbsp;
Community Support Team _ Amy
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

anonymous · Answer

Hi,&nbsp;Thanks you so much for getting back to me on this as&nbsp;I have wrote the logic out in the attached file, let me know if it is not clear.&nbsp;What I have is in green, &amp; what I need is highlighted in red&nbsp;Doc IDCountry 1Assigned to column&nbsp;Count of workflowsReassignFinal count of workflows&nbsp;Divide doc ID's that are from country 1 between 2 employees&nbsp;Reassign all other Doc ID's equally between other employees but also assign some of these to Country 1 employees (Using the RAND BETWEEN function to assign)Count of occurancesI need a column to identify that that Employee A has gotten too many Doc ID's and to take away some of the Doc ID's from them and reassign them back to Employee B &amp; C so that all employees have a similar amount of Doc IDs. (It is okay if not a even split as RAND BETWEEN function does not give this)Count of occurances1&nbsp;Employee B4Employee B52Employee AEmployee A8Employee A53&nbsp;Employee B4Employee B54&nbsp;Employee C3Employee C55&nbsp;Employee A8Employee B56&nbsp;Employee A8Employee A57Employee AEmployee A8Employee A58&nbsp;Employee B4Employee B59&nbsp;Employee C3Employee C510&nbsp;Employee C3Employee C511&nbsp;Employee A8Employee C512Employee AEmployee A8Employee A513&nbsp;Employee B4Employee B514&nbsp;Employee A8Employee C515Employee AEmployee A8Employee A5&nbsp;Kind regards,Katie

Forum Discussion

Assignment of rows

3 Replies

Related content

Priority Based Sales Rep Assignment

Assigning users row level security roles

Manually Assign Certain Rows as Column Headers

Assign (Transfer) Ownership

Buttons assigned to bookmarks not working

Doc ID	Country 1	Assigned to column	Count of workflows	Reassign	Final count of workflows
	Divide doc ID's that are from country 1 between 2 employees	Reassign all other Doc ID's equally between other employees but also assign some of these to Country 1 employees (Using the RAND BETWEEN function to assign)	Count of occurances	I need a column to identify that that Employee A has gotten too many Doc ID's and to take away some of the Doc ID's from them and reassign them back to Employee B & C so that all employees have a similar amount of Doc IDs. (It is okay if not a even split as RAND BETWEEN function does not give this)	Count of occurances
1		Employee B	4	Employee B	5
2	Employee A	Employee A	8	Employee A	5
3		Employee B	4	Employee B	5
4		Employee C	3	Employee C	5
5		Employee A	8	Employee B	5
6		Employee A	8	Employee A	5
7	Employee A	Employee A	8	Employee A	5
8		Employee B	4	Employee B	5
9		Employee C	3	Employee C	5
10		Employee C	3	Employee C	5
11		Employee A	8	Employee C	5
12	Employee A	Employee A	8	Employee A	5
13		Employee B	4	Employee B	5
14		Employee A	8	Employee C	5
15	Employee A	Employee A	8	Employee A	5