Refer inactive relation table column in Direct Query

[Panchaks60]

I am sourcing a shared dataset in my Desktop report which is Direct Query mode.

I want to refer a inactive relationship table column.

I cannot alter the datamodel.

I have tried below options but not working.

1) Related function is not allowing me.

2) VLOOKUPVALUE also not allowing.

3) USERRELATIINSHIP in Calculate also not working as I want the other column result for every row 

Is there any alternative for solving the scenario.

Thanks in advance.

[Greg_Deckler]

@Panchaks60 Are you trying to create a measure? You could try using MAXX(FILTER(...),...). Also, VLOOKUPVALUE is LOOKUPVALUE in DAX.