Data Relationships

I would recommend creating a third table to be a bridge table like this:

Table3 =

  DISTINCT(

    UNION(

      SELECTCOLUMNS('Table1',"Name",[Name]),

      SELECTCOLUMNS('Table2',"Name",[Name])

    )

  )

Create your relationships to both of your tables and use this bridge table in your visuals for Name.

Hi mkornel ,

You can try to create a new calculate table:

Table =
ADDCOLUMNS (
    'Table A',
    "Cost",
    VAR x =
        LOOKUPVALUE ( 'Table B'[Cost], 'Table B'[Name], 'Table A'[Name] )
    RETURN
        IF ( ISBLANK ( x ), 0, x )
)

You will get the result like your expected:

Here is the demo, please try it: PBIX 

Best Regards,
Yingjie Li

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