Measure that divides a value from another table, with a sum from another table
Hello, I have a problem which I'm having problems getting my head around, which I am hoping for any inputs on. I have two tables. One date table with available hours for a given month, and another table containing "executed hours" for a given month per employee and performed task. See examples below. Executed hours Date table Wanted output The wanted output is a table that show the number of full time employees for a given month. If any employee has worked over the avaible hours for a respective month it rounded down to 1, whilst if exected hours is below available hours I want the fraction (as shown for employee 2 in januar). I have managed all the numbers right, apart from the totals (totalsum) which still eludes. Hopefully this makes sense. Thank you for your time!
