Forum Discussion
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...
Panchaks60 Are you trying to create a measure? You could try using MAXX(FILTER(...),...). Also, VLOOKUPVALUE is LOOKUPVALUE in DAX.