Forum Discussion
lookupvalue error
how can i solve this error A single value for column 'Ticket ID' in table 'TT' cannot be determined. This can happen when a measure formula refers to a column that contains many values without sp...
Hi kadwy ,
Based on my test, the formula you used is applied to column but not measure.
So you may try this:
Yes/NO Column = IF(LOOKUPVALUE(TT[Problem ID],TT[Problem ID],TT[Ticket ID])=BLANK(),"No","Yes")or
Yes/NO Measure = IF(LOOKUPVALUE('TT (2)'[Problem ID],'TT (2)'[Problem ID],MAX('TT'[Ticket ID]))=BLANK(),"No","Yes")The final output is shown below:
If it's not you expected, please provide me with more details about your table and your expected output or share me with your pbix file after removing sensitive data.
Refer to:
https://docs.microsoft.com/en-us/dax/lookupvalue-function-dax
Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thank you
- but I need a formula like VLOOKUP
if a1=value in table 1 yes if not no