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.
1 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 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?
I had no idea this was possible 😊 It opens up a whole new world of possibilities. Thank you so much, it solved my problem.
