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 ) )

     

     

Anonymous's avatar
Anonymous
Not applicable
5 years ago

PaulDBrownemm... changed but get same blank column

 

PaulDBrown's avatar
PaulDBrown
Community Champion
5 years ago

Anonymous There's something wrong in the syntax. Let the Intellisense spell out the fields for you.

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    PaulDBrown, I was using the auto-complete, or say Intellisense spell, still not working, seems I shall use "let...in..." DAX, will post another thread to ask how to get union unique value from tables.

    Anyway, thank you for the answers and ideas to resolve this.