Forum Discussion

mahra-in's avatar
mahra-in
Helper II
8 years ago
Solved

Manage Relationship between two tables without unique values

Hi   I need to manage a relationship with two tables   Table 1   Region Spend ASEC 54555 EMEAI 64363 EMEAI 45455 ASEC 5554 AMER 2254 ASEC 2244 AMER 55558   ...
Need Help
  • v-yulgu-msft's avatar
    v-yulgu-msft
    8 years ago

    Hi mahra-in,

     

    You need to create a bridge table named as 'Table3'.

    Table3 =
UNION (
    VALUES ( Table1[Region] ),
    EXCEPT ( VALUES ( Table2[Region] ), VALUES ( Table1[Region] ) )
)

    Create a one-to-many relationship from 'Table3' to 'Table1' and 'Table2'.

     

    Then, drag 'Table3'[Region] and 'Table1'[Spend] and 'Table2'[Savings] to visual.

     

    Best regards,

    Yuliana Gu

RolandsP's avatar
RolandsP
Resolver IV
8 years ago

You need to create a Bridge table with only one column that contains unique Region values. Then you can link Table1 and Table2 through the Bridge table.