Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

power Query

I would need inputs in desiging of the data model. i have three tables (A,B,C,D)   Joining by Shipto ID between A,B,C and D A join with D (Ship to ID) B Join D (Ship to ID) C Join D (Ship ID) A...
Need Help
  • v-xicai's avatar
    v-xicai
    6 years ago

    Hi   Anonymous ,

     

    Does that make sense? If so, kindly mark the proper reply as a solution to help others having the similar issue and close the case. If not, let me know and I'll try to help you further.

     

    Best regards

    Amy

v-xicai's avatar
v-xicai
Community Support
6 years ago

Hi Anonymous ,

 

You may create active relationships between A,B,C and D on Ship to ID with ticking the option "Make this relationship active", and create inactive relationships between B, C and D on Submitted by ID without ticking the option.

Then if you need to use the inactive relationships for field Submitted by ID, you can create measure using USERELATIONSHIP function like DAX below.

 

Measure1= CALCULATE(COUNT(D[Submitted by ID]),USERELATIONSHIP(B[Submitted by ID], D[Submitted by ID]))

 

Best Regards,

Amy

 

Community Support Team _ Amy

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.