Create a new measure based on conditions in another table

[Anonymous]

Hello

I would like to create a measure to calculate the costs for each employee in Table A, based on information in Table B, shown below

The two tables are linked by Z_Division_SK in both tables.

What I want to do is that, if an employ in team "Sales" in Table B, the cost of the employee at that time = "Travel Distance" * 1.69, otherwise = "Travel Distance" *1.35

I use the following

Costs =
IF(
 RELATED('Table B' [Team])= "Sales",
SUMX('Table A',[Travel Distance]*1.69),

SUMX('Table A',[Travel Distance]*1.35))

Then I got error message saying Table B doesn't exist or doesn't have relationship with Table A

The data I use for the calculation is not directly linked but the two tables are linked.

Is my task achievable? 

Your help is much apprecated. Thanks in advance.

[ryan_mayu]

pls provide update the sample data. We need the columns that can be linked between two tables and what's the expected output? that will help us to check if the solution is correct.

[Anonymous · Accepted solution]

I solved the issue. Rather than creating a measure, I create a new colunm. Then it works well.

Thank you for your attendation.

[ryan_mayu]

you are welcome