Need Help on Lookup Value & Relationship Table

[acarolina]

Hi All, 

I have a table containing something like this: 

Basically, I want to get the code. So, I combined the excel to the existing database in PBI. 
There's similar info like Basin & GU under Organization table, but Country is under People table. 

So I made this formula - creating a new column in Organization table namely "X Code" and I want to lookup into excel file that I have above. However, since Country section is on another table, I cannot tag it into my equation. 

Do you have any other alternatives?

X Code =

LOOKUPVALUE(
'X Code'[MSK X Code],
'X Code'[Basin (Code)], 'Dim Organization'[Basin (Code)],
'X Code'[GU (Code)], 'Dim Organization'[GeoUnit (Code)],
'X Code'[Country], RELATED('Dim People'[Country])
)

[lbendlin · Accepted solution]

Please consider using TREATAS instead.  It has much better performance.