Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric 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 |
---|---|
77 | |
75 | |
67 | |
65 | |
47 |
User | Count |
---|---|
108 | |
105 | |
93 | |
83 | |
65 |