Forum Discussion
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 it.
Then I created Table 3 with only "Month" dimension.
I create the relationship Table 1 to Table 3 and that is fine, but when I create the relationship between Table 2 and Table 3 I can't make it active, as I get this error message: "you can't create a direct active relationship because an active set of indirect relationship already exists", saying that it would create an ambiguity between Table 1 and Table 2.
Thanks in advance for any support
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:
6 Replies
Do any joins exist between Table1 and Table2?
Not direct, but I think there is some indirect relation with the field "Product", as they both are linked to the table with product details.
I think that is the problem, but I cannot break that relationship..
Hi,
Just as you created a Month dimension table, you should also create a Product dimension table. Remove any relationships between Table1 and Table2.
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:
