Forum Discussion

blytonpereira's avatar
blytonpereira
Helper II
7 years ago
Solved

Multiple Bridge tables vs single bridge table

Hello,   I have a Table A with Columns:   Name, Address, Value   I have Table B with Columns: Name, Address, Value   In table A and B there are duplciates of Name and Addresses.   I have a Br...
Need Help
  • v-lili6-msft's avatar
    v-lili6-msft
    7 years ago

    hi, blytonpereira

    First, Then I can drag Name or Address from Table A or B into my dashboard andit will display correct values?

    You need to drag name or Address from Name table or Adress table.

    for example:

     

    Second, If you want to just create one bridge table and drag the address from table A or B.

    You need to change cross filter direction from singel to Both.

     

    But this will lead to a new issue.

    For example:

    In the table A C3 value is 8 and table B C3 value is 5, and I create a one to many relationship and single direction filter from my Bridge table (Name) to Table A and B.

    Then I drag address from table A into slicer and filter C3.

    Filter value in table B is B1 and B2! Because their relationship is based on Name column, when you filter address in table A,

    It will filter table B by the name column. 

     

    So the best way for your case is the method that using two bridge like above.

     

    Best Regards,

    Lin

     

     

     

     

     

     

     

     

blytonpereira's avatar
blytonpereira
Helper II
7 years ago

So that means I need two bridge tables....one for Name and one for Address and the conenct each of these Bridhge tables to Table A and B via a BI direction filter one to many ........Then I can drag Name or Address from Table A or B into my dashboard andit will display correct values ?

 

How about creating just one bridge table for Name with bi directional filter . Why does'nt this option work ?

v-lili6-msft's avatar
v-lili6-msft
Community Support
7 years ago

hi, blytonpereira

First, Then I can drag Name or Address from Table A or B into my dashboard andit will display correct values?

You need to drag name or Address from Name table or Adress table.

for example:

 

Second, If you want to just create one bridge table and drag the address from table A or B.

You need to change cross filter direction from singel to Both.

 

But this will lead to a new issue.

For example:

In the table A C3 value is 8 and table B C3 value is 5, and I create a one to many relationship and single direction filter from my Bridge table (Name) to Table A and B.

Then I drag address from table A into slicer and filter C3.

Filter value in table B is B1 and B2! Because their relationship is based on Name column, when you filter address in table A,

It will filter table B by the name column. 

 

So the best way for your case is the method that using two bridge like above.

 

Best Regards,

Lin