Forum Discussion
Cannot create active relationship
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
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 ) )
Thanks for reply.
I am quite new to Power BI, seems I get nothing retured after apply the DAX:
Could you please help further?
Thanks!
H
Anonymous
Just make sure the syntax for the tables and fields is correct. When writing the DAX, select the appropriate field from each table. For example, my text needs the ' ' to establish the table (which isn't included in the text I wrote. For example:
'Queries_byPage_byDate_byGeo'[Country]Anonymous There's something wrong in the syntax. Let the Intellisense spell out the fields for you.