Forum Discussion
bridging table with unique entries to create relationship between 2 nonunique tables not working
Hi, I'll be very specific here as it may be some minutae of what I'm doing that is preventing this from working. I have two tables :- Bugs and Results. Both contain a FailureCategoryID column, but t...
BetterCallFrank
Resolver IV
Resolver IVHi Dave,
can you please post a screenshot of your data model?
And also the DAX you used to create the bridging table
helps us helping you :-)
Frank
Thanks Frank. To create the contents of the bridge table, I did the following:-
- In Query Editor right-click on the table FailuresFromKusto and column failureBucketID (I need unique values for this column as that is the one I want the relationship to the BugDataFromOasys built on).
- Add the bottom of the menu select ‘Add As New Query. This will create a new list with all the values from that column
- On the newly created list right-click and select ‘Remove Duplicates’
- When that is complete right-click on the list and select ‘To Table’. Rename column and table to FailurebucketID and FailureBucketId_kusto.
- Close & Apply your changes
- Create the new relationships. They create OK as per the diagrams below, but then the problem as outlined in the original post exists.
- BetterCallFrank
dave_blount double click each relationship and try to set its direction to "both"
should do the trick :)
HTH,
Frank
Thanks Frank, but that has the same error (I'd tried this already ) also the order of which table was on which side of the relationship.