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:

     



timahenning's avatar
timahenning
Frequent Visitor
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: