Forum Discussion

dave_blount's avatar
dave_blount
Regular Visitor
9 years ago

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...
dave_blount's avatar
dave_blount
Regular Visitor
9 years ago

BetterCallFrank's avatar
BetterCallFrank
Icon for Resolver IV rankResolver IV
9 years ago

dave_blount double click each relationship and try to set its direction to "both"

 

should do the trick :)

 

HTH,

Frank

  • dave_blount's avatar
    dave_blount
    Regular Visitor
    9 years ago

    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.

    • dave_blount's avatar
      dave_blount
      Regular Visitor
      9 years ago

      Also, just to add, I did also try creatingthe bridging table via DAX (see below) and creating the relatonships then, but problem is the same.

      FailureBucketUnique = DISTINCT(FailuresFromKusto[FailureBucketId])

      • Anonymous's avatar
        Anonymous
        Not applicable
        9 years ago

        I'm new here, so forgive me if I'm off base, but it sounds like the data structure is correct, it's the table that you're trying to produce that is causing the issues. The Bugs table entry can map back to a unique entry in the Bridging Table, but when you try to pull in fields from the Results table, Power BI has no way to know which entry to pull in as there could be multiples. 

         

        I'm struggling to visualize the table you're trying to create, what data are you trying to pull in from the reults table for each bug?