Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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)
Also B,C Joining with D(New instance table) Submitted by ID
B Join D (submitted by ID)
C Join D (Submitted by ID)
The problem is need show the data from A,B (Shipto ID) tables along with C (Join with Submitted by),but its not giving the exact results when I pull the data from these three tables in power BI report.
what is the best apparoch to make efficent relationship between these 4 tables (A,B,C,D). Compoiste joining is not allowing.
each table has its own data ,so we can't combined the data between these 4 tables.
Solved! Go to Solution.
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
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
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.
@Anonymous , Did not get it completely. But you can create a concatenated column in both tables and join it
New column like
New key = [Column1] &"-" &[Column2]
How does it work? which table to which table the join should make? how it effect on end results.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
97 | |
75 | |
63 | |
53 |
User | Count |
---|---|
144 | |
103 | |
98 | |
85 | |
64 |