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.
Dear all:
I have 4 tables all of them with a column called Demand ID which is used to relate the primary table (A) to the other tables. So Table A (primary) has a relationship (one to many) with table B, C and D. Cross Filter Direction is set to Both in all relationships.
The problem I have is that when I create a visual, let's say a table, pulling colums from table B and C, or C and D, or D and B, I got the following error message --> Relation Detection "There is a missing relationship between these fields. Use Autodetect to search relationships, or create them Manually"
If I try to create a relationship between tables B, C, and D, it remains inactive, due to the already existent realtionship with table A.
I though that if each secondary tables has a relationship with the primary table, all secondary table were going to be also related to each other, but it seems that this is not working in this case.
Any help would be appreciated!
Thanks!
Hi, @Netope
Could you please tell me whether your problem has been solved?
For now, there is no content of description in the thread. If you still need help, please share more details to us.
Best Regards,
Community Support Team _ Eason
Hi , @Netope
Can you show relevant screenshots about the relationship between the tables in your model
Best Regards,
Community Support Team _ Eason
@Netope , Not very clear. But as a is the central table. You can analyze the Calculated/summarized column/measures from B,C,D with A. You can take an unsummarized column only from one table b or c or D.
If there is any other common field like date or any other. Have common tables for that.
https://www.youtube.com/watch?v=Bkf35Roman8
@Netope Can you try changing the cross filter direction of one of the relationship either between A and B or A and C to single direction and check whether if its working or not ?
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 |
---|---|
108 | |
98 | |
78 | |
66 | |
53 |
User | Count |
---|---|
139 | |
100 | |
95 | |
85 | |
63 |