Forum Discussion

lcasey's avatar
lcasey
Post Prodigy
9 years ago
Solved

Lookup Values and Measures

Hello,   Is it possible to use lookupvalue in a measure and not a calculated column?     Measure = LOOKUPVALUE('Table'[Balance],'Table'[CUSTNMBR],   I cant use a measure as the table I am tryi...
  • v-sihou-msft's avatar
    9 years ago

    lcasey

     

    What you apply as the first argument in LOOKUPVALUE() function must be a column. Measure is not a column of values. It need to be sliced and evaluated with current context to get result which can't be used in LOOKUPVALUE() function.

     

    Regards,