Forum Discussion

kadwy's avatar
kadwy
New Member
5 years ago

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 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")

 

 

Need Help

5 Replies

  • arvindsingh802's avatar
    arvindsingh802
    Community Champion
    5 years ago

    Create column not measure

     

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    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's avatar
      kadwy
      New Member
      5 years ago

      Thank you

      • but I need a formula like VLOOKUP

      if a1=value in table 1   yes if not no

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    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's avatar
    Anonymous
    Not applicable
    5 years ago

    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