Fetch values based on filter from other table with inactive relationship

[Anonymous]

Hi All,

I have a relationship between two tables which is inactive. 

Filter is based on table 1 and values in table is based on table 2. 

Now I want to show only the values present in Table 2 based on date selected in Table1.  The value I wanted is not a number and cannot use SUM, AVERAGE etc. 

I have tried using 

Related Project = CALCULATE(
CALCULATE(
VALUES('Portfolio'[Project]),
Portfolio
),
USERELATIONSHIP ('Portfolio'[Portfolio Project Number], 'Project Dependency'[Related Project Number]),
ALL ( Portfolio )
)

This is giving me circular dependency and I have read articles on circular dependency but I couldn't resolve it. 

Help will be really appreciated. 

Cheers

Shruti

[v-chuncz-msft · Accepted solution]

@Anonymous,

It seems that you may simply use LOOKUPVALUE Function.