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 ) )
That's strange. An inactive relationship has no effect until you "activate it", and adding fields from the same dimension table should be fine. You can try and delete the inactive relationship or split the dimension table into two dimension tables, but I don't see why you are getting this behaviour.
Maybe my explanation might help you understand what's going on.
So I've one table which has the actual data and 3 tables that are budgets for 3 different departments.
In order to get the positions through one source for my visual, I created a position mapping table which is based upon the actual data.
Than I linked all the files (actual and budgets) to this table. The budget files are working fine, although the actual table is inactive. Plus when I'm pulling data from the tables with the dimension table as the base. The data from actual table is showing blank.