Lookup Values and Measures

[lcasey]

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.

[v-sihou-msft · Accepted solution]

@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,

[lcasey]