Forum Discussion

uif19085's avatar
uif19085
Helper III
3 years ago
Solved

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?