Average hourly Income. Help with formula please

[TapZxK]

Hi All, 

Here I am again with another question for my Power BI Report.

What I'm looking to find out is the hourly Income for projects. the logic should be like so. 

For Project Sparrow Total Billed in September is 100,000 Euro and total reported hours for Sparrow in September are 1200 Hours.

For Project Legacy Total Billed in September is 16,000 Euro and total reported hours for Legacy in September are 360 hours.

Sparrow Total Billed / Total Hours = 83.3 Euro hourly rate.

Legacy Total Billed / Total Hours = 44.4 Euro hourly rate.

Overall Total Billed / Overall total Hours = 74.3 euro hourly rate.

I have the following tables:

Resource Hours (Data)

Project Billings (Data)

connected to

Project_Lookup (Lookup Table)

Calendar (Lookup Table)

Thank you for your help. 

BR,

Kris

[JirkaZ · Accepted solution]

@TapZxK This should be a simple measure like:

CALCULATE(DIVIDE(SUM(money), SUM(hours), 0)
The rest should be evaluated within a context (table visual with project rows and this measure added)