cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
DCrowther Regular Visitor
Regular Visitor

Lookupvalue Columns in DirectQuery - How to relate DirectQuery data

Hi

I am new to DirectQuery data, and i am trying to create additional columns that relate and pull through related data from other tables for the visuals. I know that the normal LOOKUPVALUE only works in DirectQuery by creating a MEASURE then performing the LOOKUPVALUE formula within the measure.

 

The problem i have is that LOOKUPVALUE using Measures only seems to then pull back other data from other Measures in the related table, so if none of my related columns are measures, I cannot relate the data or create additional lookupvalue columns  ??

 

Am i supposed to some how turn existing test or numerical columns into Measures? if so can you help how i do this?

 

Regards

Dan

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Lookupvalue Columns in DirectQuery - How to relate DirectQuery data

@DCrowther ,

 

You may try adding SELECTEDVALUE.

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
1 REPLY 1
Community Support Team
Community Support Team

Re: Lookupvalue Columns in DirectQuery - How to relate DirectQuery data

@DCrowther ,

 

You may try adding SELECTEDVALUE.

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.