Forum Discussion
lcasey
Post Prodigy
Post ProdigyLookup 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.
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
lcasey
v-sihou-msftMicrosoft Employee
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,