Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
IvoM
Frequent Visitor

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:

 

IvoM_0-1706274419201.png

The result is this:

 

IvoM_1-1706274472259.png

 

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

 

IvoM_2-1706274524518.png

 

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
bchager6
Super User
Super User

@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?

View solution in original post

3 REPLIES 3
bchager6
Super User
Super User

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

bchager6
Super User
Super User

@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
Frequent Visitor

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

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.