Allocate percentage of total

[Anonymous]

Hello,

I am trying to build a report of Team Leads, Employees, Employee hours entered, and overtime hours.  I would like the overtime hours to allocate to each Team Lead the Employee worked for based on the percentage of total hours.  For example:

Charles worked a total of 69 hours.  17 hours were for Joe, and 52 hours were for Sue.  He had 29 hours of overtime (69-40).  His overtime will be multipled by 1.5 to correspond to overtime pay.  24.6% of his overtime would allocate to Joe, and 75.4% of his overtime would allocate to Sue.

Any ideas how to make this work?  I would like it to ultimately look like this:

Thanks!

[dethompson97]

I am also new to DAX and learning and took this on as a challenge.  I entered your data into an Employee Hours table and tried to do what  you were looking for.  I hope this helps point you in the right direction.

Hope this helps!

Dawn Thompson

PS:  If this solution works, please mark it as a solution to help others. Kudos are nice too.

[dethompson97 · Accepted solution]

I added another employee to make sure things worked and also took a snip of my data model so you could see that too.  I also seperated the measures into a seperate table so the solution is cleaner and then combined some of the calculations into one so that you could see that too.

Hope this helps!

Dawn Thompson

PS:  If this solution works, please mark it as a solution to help others. Kudos are nice too.

[Anonymous]

@dethompson97  You say you're new to this, but to have worked this out - and so quickly - I think you're further along than you give yourself credit for!  I tried it with some sample data and it worked perfectly!  My actual data will have many other factors that I will work into the calculations, but you gave me the push I needed... thank you!