Sum Hours with a Group By date in a Column/Measure

Hi all,

I am trying to create a column/measure that takes a count of orders and divides it by the hours worked by an employee on a given day to get the average order per hour. In the query, I am joining the hours per day on each order, so I think PowerBI is summing those up when I need it to group by date when actually manipulating the data. I cannot aggregate and group by in the query or I lose the ability to export detailed information in PowerBI on each order.

Here is a fake data set of the relevant columns:

Here is a table with what is returning in PowerBI and what I want it to show instead:

Here is the DAX for my column: Average Orders Per Hour = DIVIDE(count(Query1[orders]),sum(Query1[hoursworked]))

Appreciate any and all help!

-Josh