Forum Discussion

HitcH's avatar
HitcH
Helper II
3 years ago
Solved

Third table relationship

Hello powerBI people! This is my problem Table 1: Month, Product, Sales Table 2: Month, Product, Target I want to create a realtionship with "Month", but the field is not unique and so I can't do...
Need Help
  • timahenning's avatar
    timahenning
    3 years ago

    Here is my guess to your problem. You may have an existing relationship between table1 and table2. When you are trying to create an active relationship between your month dimension and table2, you get an ambiguity error.  There would be two possible paths for the engine to get to table2.

    Have you thought about this design?

    It will allow you to filter and group by these dimensions:

     



Ashish_Mathur's avatar
Ashish_Mathur
Super User
3 years ago

Hi,

Just as you created a Month dimension table, you should also create a Product dimension table.  Remove any relationships between Table1 and Table2.

HitcH's avatar
HitcH
Helper II
3 years ago

Thank you Ashis!
One additional question, now I could handle it, but I still have some problem on the Month relationship:

You can see the two tables connected to each other via the "match" table in the middle. Still if I create a table with YearMonth1 and YearMonth2 together I get an error (while I can create YearMonth1 with YearMonthMatch or YearMonth2 with YearMonthMatch singularily). What am I still missing? 😞

 

Thanks again!