Forum Discussion
Traceability with Many to Many Relationship
Hello, I don't have much experience with PowerBi and now i'm strugle with some many to many tables relationships, basicaly i have to find a way to count some "Requirements" which are "InLink" with others. I'll explain in a bit. To get a Requirement i had to make some computation over a some new columns, i've flag every one with 1 if the Identification cirteria doesn't match it will be 0. Like this:
In this Table i also have some IDs with which i can determine the many-to-many relationship in this manner: I have an ArtefactID(Table1) which is having a one to many relationship with Artefact ID (Table2) here in Table2 we will find another ID called InLink ID which is having a correspondent in Table1 with another id called UniqueId. These IDs tells me which of those Requirements are link with another. Here some visual to understand what i'm trying to say (The * indicates the relationships):
For example, here for 150023(Table1) ( let's say this is the ID for a Software Requirement ) will have a many correspondents in Table2 and also here we will find an InLink Id that will have the correspodent back to Table1 in UniqueId and that's how i get "InLink" "Requirements" and will be the id of 15450 and this will be an Hardware Requirement, so our Software Requirement will have an Hardware Requirement inlinked. I want to find a way to make this logic as a Filter or something. Here for example i need to count the number of inlinked Requirements for the Software Requirement one's. What do you recomand, what is the best way?
- Anonymous3 years ago
HI uif19085,
You can try to extract two table field values and use them create a new table as bridge to link tables or concatenate multiple columns to create a unique value and use it as the key of table relationship mapping.
How to Join Many to Many with a Bridge Table in Power BI (seerinteractive.com)
Create a relationship with multiple columns in Power BI | Dan Kinsella
Regards,
Xiaoxin Sheng
1 Reply
- AnonymousNot applicable
HI uif19085,
You can try to extract two table field values and use them create a new table as bridge to link tables or concatenate multiple columns to create a unique value and use it as the key of table relationship mapping.
How to Join Many to Many with a Bridge Table in Power BI (seerinteractive.com)
Create a relationship with multiple columns in Power BI | Dan Kinsella
Regards,
Xiaoxin Sheng