Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Relationship

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 
Need Help

2 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    6 years ago

    You can create a common Table and join

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

  • v-xicai's avatar
    v-xicai
    Community Support
    6 years ago

    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.