Sum rows with same id and then divide each row for that sum

[Luca2020]

Hi, 

I've a table with ID, Hours of Working  and Date of Working. 

I'd like to calculate the completion rate for each ID for each month, like: 

ID          H                   DATE

1            2           30 JANUARY 2021

1            3           31 JANUARY 2021

1            2           01 FEBRUARY 2021

ID 1 took 7 hours of work, 5 h in january and 2 h in february. Completion Rate in January 5/7 = 71%

I need this % to divide costs and revenues according to this % (true revenue in january 100.000 € * 71%)

I'd prefer solving this with a measure but a calculated column is also fine. 

Thanks

[amitchandak · Accepted solution]

@Luca2020 , You can measure like

divide(Sum(Table[H]), calculate(Sum(Table[H]), filter(allselected(Table), Table[ID] = max(Table[ID]))))

Then multiply that with revenue

divide(Sum(Table[H]), calculate(Sum(Table[H]), filter(allselected(Table), Table[ID] = max(Table[ID])))) * sum(Table[Revenue])