Forum Discussion
Lookupvalue not possible with Direct Query?
Hi rambler ,
Yes, you're right. We cannot create calculated column with Lookupvalue function for the Direct Query mode table by my tests.
However, we could create the calculated column with Lookupvalue function for the import mode table.
In addition, we could create the measure with Lookupvalue function for the the Direct Query mode table.
However, creating the calculated column in the imported table results in an error message for the DAX stating:
"A single value for column [ColumnX] in table [Table] cannot be determined. This can happen when a measure formula refers to a column that contains many values without specifying an aggregation such as min, max, count, or sum to get a single result."
For this error message, could you share the data sample and your formula which could reproduce the issue so that I could do a research on it?
Best Regards,
Cherry
Hi rambler ,
Have you solved the problem?
If you have solved, please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.
If you still need help, please feel free to ask.
Best Regards,
Cherry
Hi Cherry
Many apologies for the late response. Other commmitments got in the way.
In order to post to some data, I would have to create a dummy dataset that would reproduce the error. Unfortunately, I am unable to do that at the moment.
If I do get the error message again, is it okay to resurrect this thread to update it? Or is starting a new one the preferred method?
Many thanks for your time, help, and patience
Rambler