Relationships with missing data

[Anonymous]

Hi all. I need to create a relationship connecting table 1 and table 2.

If I create a link using only ID 1, some data will be lost. Likewise for ID 2.

Is there a way of using both ID 1 and ID in table 2 to link to Table 1?

Thank you

[PattemManohar]

@Anonymous Hmm, you can split the first table into two separate tables (FirstName and ID1) (FirstName and ID2). Then link the table2 to these two tables by ID1 and ID2.

[Anonymous]

Unfortunately your solution provides this. The first Name and Last name should show all data from both columns

[v-cherch-msft · Accepted solution]

Hi @Anonymous

After splitting the first table. You may set the relationships as below. Then you may create a measure to get all the FirstName.

UpdateFirstName =
IF (
    MAX ( '1(1)'[First Name] ) = BLANK (),
    MAX ( '1 (2)'[First Name] ),
    MAX ( '1(1)'[First Name] )
)

Regards,

Cherie 

[Anonymous]

Hi @v-cherch-msft

Using your method, will I have to create a new measure for every subsequent column e.g.

UpdateFirstName, UpdateEyeColour,UpdateShoeSize etc?

Many thanks