Forum Discussion
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
- AnonymousNot 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,