Relationship

[Anonymous]

How to relate the Concatenate Column of this two tables in the given scenario as both columns have few lines which are not existing in the concatenate column of other table?

Cost Table
Country	VP	GM	Concatenate
USA	XYZ	XYZ/A	USA/XYZ/A
India	XYZ	XYZ/B	India/XYZ/B
Japan	XYZ	XYZ/C	Japan/XYZ/C
UK	XYZ	XYZ/D	UK/XYZ/D

Staff
Country	VP	GM	Concatenate
USA	XYZ	XYZ/A	USA/XYZ/A
India	XYZ	XYZ/B	India/XYZ/B
Japan	XYZ	XYZ/D	Japan/XYZ/D
Germany	XYZ	XYZ/E	Germany/XYZ/E

[v-xicai]

Hi @Anonymous ,

You may create intermediate calculated table like DAX below, then create relationships with original two tables in "Both" Cross filter direction.

Intermediate Table= UNION(DISTINCT(Cost[Concatenate]), DISTINCT(Staff[Concatenate]) )

Best Regards,

Amy 

Community Support Team _ Amy

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

You can create a common Table and join

Concatenate Table = union(all(Table[Concatenate1]), all(Table2[Concatenate]))