Calculate figures from one table as percentage of figures from another table

[alexamatthews]

I have 2 tables; one give the quoted time to complete a certain activity, and the other is actual time spent on the same activity. The second table is live data from timesheets. They give a customer name, activity name, and number of hours spent/quoted for that activity. 

Time Quoted Table:

Customer	Activity	Hours
CompanyA	Build	20
CompanyA	Test	10
CompanyB	Build	40
CompanyB	Test	20
CompanyC	Build	50
CompanyC	Test	30

Timesheet Table:

Customer	Activity	Hours
CompanyA	Build	5
CompanyA	Build	5
CompanyA	Test	9
CompanyB	Test	10
CompanyB	Test	10

I have linked the tables and can compare the two side by side. Is it possible to give the time spent (table 2) as a percentage of the time quoted (table 1)?

In the second table, the same company/activity combination could appear more than once so it would need to be the sum of all relevant lines. For example, for the Build Phase for CustomerA, the time spent is 50% of the quoted time.

Thank you

[amitchandak · Accepted solution]

Try

new column in Timesheet  = sumx(filter('Time Quoted','Time Quoted'[Customer]=Timesheet[Customer] 
	&& 'Time Quoted'[Activity]=Timesheet[Activity] ),'Time Quoted'[Hours])

[alexamatthews]

Thank you @amitchandak it works! I changed the result slightly to give the result of time spent as percentage of the quoted amount, but otherwise does exactly what I needed 🙂