lookupvalue error

[kadwy]

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 specifying an aggregation such as min, max, count, or sum to get a single result.

Yes/NO = IF(LOOKUPVALUE(TT[Problem ID],TT[Problem ID],TT[Ticket ID])=BLANK(),"No","Yes")

[Anonymous]

Hi @kadwy ,

Could you tell me if your problem has been solved? If it is, kindly Accept it as the solution to make the thread closed. More people will benefit from it. 

If not,please provide me with more details about your table and your problem or share me with your pbix file after removing sensitive data.

Hope to hear from you😀

Best Regards,
Eyelyn Qin

[Anonymous]

Hi @kadwy ,

It's suggested to provide me with more details about your table and your expected output or share me with your pbix file after removing sensitive data.

Best Regards,
Eyelyn Qin

[Anonymous]

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.

[kadwy]

Thank you

• but I need a formula like VLOOKUP

if a1=value in table 1   yes if not no

[arvindsingh802]

Create column not measure

If this post helps, then please consider Accept it as the solution and give it a thumbs up