Forum Discussion

rambler's avatar
rambler
Regular Visitor
7 years ago
Solved

Lookupvalue not possible with Direct Query?

Hello   I think that this is a bit like the following:   https://community.powerbi.com/t5/Desktop/Lookupvalue-function-not-appearing-Direct-Query-mode/m-p/455048#M210841   but maybe not.   I ...
Need Help
  • v-piga-msft's avatar
    v-piga-msft
    7 years ago

    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

     

v-piga-msft's avatar
v-piga-msft
Resident Rockstar
7 years ago

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