Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Cannot create active relationship

Hi there,   It's found I cannot create direct relationship on the new added table. From table "Queries....": Country to table "General_Performance..." Country     When I try to change the...
Need Help
  • PaulDBrown's avatar
    PaulDBrown
    5 years ago

    Anonymous 

    The reason you are getting this message is because both tables have a relationship with the calendar table, and the new filter would create a conflict since it would also indeirectly filter the date field.

    The way to solve this is to create a new dimension table  containing unique values for country from both tables, and then joining this Country Dimension Table with both your tables in 1:* relationships.

    The process is simple. Create a new table in the riboon and type in:

     

    Dimension Country =
VAR Table1 =
    DISTINCT ( Queries_byPage_byDate_byGeo[Country] )
VAR Table2 =
    DISTINCT ( General_Performance_By_Geo[Country] )
RETURN
    DISTINCT ( UNION ( Table1, Table2 ) )

     

     

luapdoniv's avatar
luapdoniv
Resolver II
5 years ago

Seems to me like the Country is not UNIQUE in the table. You can create a new unique country table and then create the relations. Use the country from the newly created unique country table in your views.

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    That's right. The country column is in a by date table, so there are unique value appears many rows.

    Moreover, there will be another table contains similar column "Country" but the value will not be "can, jpn, usa", will be "Japan, Canada, America", etc...