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 trying to use as a lookup is aggregating the customer number.

 

 

 

Need Help
  • v-sihou-msft's avatar
    v-sihou-msft
    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,

2 Replies

  • v-sihou-msft's avatar
    v-sihou-msft
    Microsoft Employee
    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,