Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
Solved! Go to Solution.
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,
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,
User | Count |
---|---|
98 | |
89 | |
82 | |
70 | |
67 |
User | Count |
---|---|
115 | |
104 | |
101 | |
72 | |
64 |