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 ) )
Yes I am.
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.
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.