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 ) )
zubairsReplying to the content about cannot create active relationship, do you think this is the similar situation what you are facing?
Cannot create active relationship - Have to create another table?
about the visual, in the visual, what dimension you are draging to the visual? if it was drag from inactive mapping table, that could cause the blank one.
The dimension table is the one linked to all the tables. What I cannot understand is that why am I getting an inactive relationship in the first place? Also, how are relationships supposed to work in such a situation? As for me the common factor between each table is the employee position mapping, and without it my analysis is incomplete.