Relations with tables

[IvoM]

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.

[Anonymous]

@IvoM  Yes it does, and you're quite welcome!

[Anonymous · Accepted solution]

@IvoM  I see that there's an inactive relationship between employes and operation history. Have you tried using the USERELATIONSHIP DAX function in your measure that involves both those tables?

[IvoM]

I had no idea this was possible 😊 It opens up a whole new world of possibilities. Thank you so much, it solved my problem.