Relations with tables

Hello everyone,

I have been stuck on this one for a while now. I have 2 dim tables:

• contract
• employes

I have fact table for OPERATION_HISTORY and ATTENDANCE

In the contract table is a list of productions for company, the employes is list of employes.

Operation_history is table containig information about operations and time needed for work. The attendance have information about how long the employe was present in work.

I would like to calculate the productivity by dividing the operation history by attendance.

I want to be able do to it for the contract and individuals.

Here is the model view:

The result is this:

When filtering the contract all is fine. But when I filter individuals:

It correctly sums the attendance but it will sum all operation history. 

I can't create the relation between employes and operation history because I already have the relation between contract and employes. If I remove the relation beween contract and employes and have relation between employes and operation history I get the same result but for attendance.

Can you point me in some direction how to solve this problem?

Many thanks.