Refer inactive relation table column in Direct Query

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.