Averagex measure in datamodel

Hi

I do have a model with several tables, two tables are interested for my issue now.
One with the dimension dates (each day one row). This table contains the working time per day (Dim_Date[Sum of Worktime]). Every Calender day has a fixed working time

Another table one with values from production (tbl Index). The production table also has working time, how long was the machine running on that day. (Index[Workhours])

Now I want to create a measure to calculate the usage per day.
I created the measure. Its working but the totals are summarized, I want them to sum of each single component and then do the calculation
Utilization_1

Please Login or Register  to view this content.

I tried to summarize the single components, same result
Utilization_2

Please Login or Register  to view this content.

Then i tried the average, also wrong results
Utilization_3

Please Login or Register  to view this content.

Did not expect that to be so hard for me

any ideas?

thanks

How did you get the total Worktime of 616? 88*7 ?



Maybe try
=DIVIDE(sum(Index[Workhours]),Sum(Dim_Date[Worktime])*COUNTROWS(Dim_MachineList))

=204/528

528 = 22 hour/day/machine * 4 days * 6 machines