Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Lookup value from another table

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

 

 

 

1 Reply

  • MattAllington's avatar
    MattAllington
    Community Champion

    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)?