Hours Charged vs Budget showing Percentage

[trobey]

I'm trying to show hours worked in the form of percentage based on what is budgeted.   I have 1 table with the budget showing how much time is budgeted for each employee by cost center.  And then I have another table showing how much time each employee has charged to their cost center.   I need an output that shows how much over or under they are in relation to the actual hours versus budgeted hours.   Any help would be greatly appreciated.  I'm sure there is a simple measure but everyone I have tried doesn't seem to work out the way I want it too.  

[parry2k]

@trobey it is very important to know how your tables are related.

Confirm if your model looks like this

- employees

- target

- actual

target, actual are related with employees table with 1 to many relationship, 1 on employee side.

[trobey]

@parry2k  I am able to determine percentage of total hours charged compared to what is budgeted for total hours, as you can see in the attached screenshot.  But what I'm trying to do is get the percentage for each cost center/project of total hours charged compared to what is budgeted for that person.   So if someone is budgeted for 100 hours in a project but they have charged 110, I need to be able to show that percentage.   Do I need to create a new measure? If so what kind of formula do I use?   Or do I need to create another table? 

[parry2k]

@trobey do one favour for me? Share pbix file with sample data and I will get back to you with solution.

[parry2k · Accepted solution]

@trobey  create matrix visual, put employee on rows and cost center on columns and following measure on values

Actual = SUM( YourActualTable[Hours] )

Budget = SUM( YourBudgetTable[Hours] )

% = DIVIDE( [Actual], [Budget], 0 )

Cheers!!