Indirect relationship between table

Question

&nbsp;Hello,&nbsp;&nbsp;I have 3 tables as given below. &nbsp;Table 3 is the user info table.&nbsp;&nbsp;I now need to get the Manager name based on the Manager Id in table2. However, i cannot create a relationship between table2 &amp; table3 due to the existence of the relationship between table1 &amp; table3.&nbsp;&nbsp;I cannot use the RELATED command in table2 since it returns the requestor name due to the existence of indirect relatioship.&nbsp;&nbsp;&nbsp;Any thought on how to solve this issue? :smileyhappy:&nbsp;&nbsp;&nbsp;

phil_seamark · Answer

Hi&nbsp;prabhupan&nbsp;Have you looked into the LOOKUPVALUE function?

prabhupan · Answer

hello&nbsp;Phil_Seamark,&nbsp;i tried LOOKUPVALUE as follows:&nbsp;LOOKUPVALUE(TABLE3[Name],TABLE3[Id],TABLE2[ManagerId]). But it retruns blank mostly.&nbsp;:smileysad:

phil_seamark · Answer

Is that because there is no match?&nbsp;&nbsp;

prabhupan · Answer

hello&nbsp;Phil_Seamark,&nbsp;Doesnt seems so. Please see the image below... in some cases you get the name (first column) &amp; for some its blank. (the manager id is in second column)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;

sankarvinop · Answer

Hi ,Try this,&nbsp;Manager Name = if( COUNTROWS(Assigment)=1, LOOKUPVALUE(User[Name],User[ID],VALUES(Assigment[Managere ID])))&nbsp;Thanks&nbsp;Sankar P&nbsp;

Forum Discussion

Indirect relationship between table

7 Replies

Related content

Indirect Relationship Needed

Relationship

How to address indirect relationship

Relationships

Relationship Issue