How to create a calculated measure using columns from two different tables without a relationship

Hi RichardLinderma ,

I create two tables and they have no relationships.

Then I create a measure and I think you can try on this DAX code.

Measure = 
VAR _OriginCity =
    MAX ( 'Origin'[city_name] )
VAR _DestinationCity =
    CALCULATE (
        VALUES ( 'Destination'[city_name] ),
        'Destination'[city_id] = MAX ( 'Origin'[city_id] )
    )
RETURN
    _OriginCity & "/" & _DestinationCity

Best Regards

Yilong Zhou

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