Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Creating a Master Bridge Table, but still getting relationship errors

I have 6 tables that all have a column that I can use to relate them to each other, lets call it "data_key".  I created a Master bridge table named "Master_key" with all the Unique values of the "data_key".  I have setup relationships from the "Master_key" table to all of the 6 data tables.  I have tried both single and both as the cross filter direction.  I have "Cleaned and Trimmed the "data_key" in all the tables, to ensure that the data is identical.

When I create a table with the "Master_key" (bridge) table and any of the other 6 tables it works properly (Master_key, data table 1).  If I add any other of the 5 data tables(Master_key, data table 1, data table 2), it gives me a relationship error.  If I leave the "Master_key" table and remove the 1st data table (Master_key, data table 2), the visual now shows the value from the "Master_key" table and the table that was added.

I am currently not using any measures to show the data, I am not sure if that would help or not.  But currently, I am only using the table columns directly.

if anyone has any ideas on what is going wroing.  Please let me know.  The data in the report is confidential, I have created a demo and attached images below.  

 

 

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable

    I have also tried to merge all the data tables into 1 large table with all the columns.  But with the actual data, it ended up being over 70 columns and 1.9B rows. when I stopped it.  I am going to see if i can figure another way to get this to work,