Lookup value from another table

[Anonymous]

Hello All,

I have a table called as Project ID master.

And i have another two tables as Contribution, and Billed Utilization.

these both tables having Project ID as a column.

I have created relation with these tables pro id column to Project ID master.

Now when i try to show values in a table,

i have choosed project id from Project Id master table, and Contribution column from Contribution table.

But when i try to choose Billed Utilization column from Billed Utilization table, then i cant, here i am getting error as

In below table added only Project ID(from Project ID master table,) and Contribution(From Contribution table)

When i try to add another column from Bileld Utilization in this table i got the below error

So how can i get the Contribution values and Bileld Utilization values from those respective tables into 

Prject ID Master table

Any suggestions to write a dax function for this,

Mohan V

[MattAllington]

It should work.  Go back and check

1. is there a 1 to many relationship from ID master to both of he other tables?
2. Have you put the correct Project ID column in your visual (from project ID master)?