Indirect relationship between table

[prabhupan]

Hello, 

I have 3 tables as given below.  Table 3 is the user info table. 

I now need to get the Manager name based on the Manager Id in table2. However, i cannot create a relationship between table2 & table3 due to the existence of the relationship between table1 & table3. 

I cannot use the RELATED command in table2 since it returns the requestor name due to the existence of indirect relatioship. 

Any thought on how to solve this issue?  

[Phil_Seamark]

Hi @prabhupan

Have you looked into the LOOKUPVALUE function?

[prabhupan]

hello @Phil_Seamark,

i tried LOOKUPVALUE as follows:

• LOOKUPVALUE(TABLE3[Name],TABLE3[Id],TABLE2[ManagerId]). But it retruns blank mostly. 

[Phil_Seamark]

Is that because there is no match?

[prabhupan]

hello @Phil_Seamark,

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

[sankarvinop]

Hi ,

Try this, 

Manager Name = if( COUNTROWS(Assigment)=1, LOOKUPVALUE(User[Name],User[ID],VALUES(Assigment[Managere ID])))

Thanks 

Sankar P

[prabhupan]

Hello @sankarvinop,

It doesnt work since table2 has more that 1 rows, so :

COUNTROWS(Assigment)=1 is always false 

[sankarvinop]

Hi,

Can you share some sample data?