Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

need assistance with relationships - ambiguity errors

So, I'm trying to connect several fact tables to a employee table and a calendar table.  I have the employee table working fine but when I try to add the calendar table, I get ambiguity errors.  The employee and calendar table contain unique values and the others contain many 


Below is how it looks.  Anything I'm missing?

 

Need Help

3 Replies

  • edhans's avatar
    edhans
    Icon for Community Champion rankCommunity Champion
    7 years ago

    Please post how it really looks from Power BI Desktop. Ambiguity normally comes from too many bidirectional relationships that DAX cannot determine a single correct path. Your image doesn't show that but it was drawn with a screenshot annotation tool, not the true relationships in Power BI.

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago
      Looks like I got it. On my training table, I had some blanks in my training date column as not every item resulted in training. Once I changed to a column that had all dates, it started working as I expected

      So, no way to use a column if there are blanks?
      • edhans's avatar
        edhans
        Icon for Community Champion rankCommunity Champion
        7 years ago

        Yes, you can use columns with blanks, but not as the 1 side of a 1 to many relationship. But not being able to see the model and which fields had the blanks, difficult to tell.