LOOKUPVALUE - Check if Column A value exist in Column B

QS7 — Thu, 10 Jun 2021 13:53:25 GMT

Hi,
I'm trying to create a new DAX measure in which I need to check for each row of my table if the value from column A exists in column B.

If it exists, then True or a value should be returned else an empty field should be returned.
Currently i have this dax formula :

IF( NOT ISBLANK( ( CALCULATE( LOOKUPVALUE( 'Sales'[ID_Ref], 'Sales'[ID_Ref], VALUES('Sales'[ID_Ticket]) ) ) ) ),"Yes","No")

As long as i'm filtering on one ticket the measure is working, but if i extend the filter on multiple tickets i have this error :

"A table of multiple values was supplied where a single value was expected".

Thank you for help.

Re: LOOKUPVALUE - Check if Column A value exist in Column B

Anonymous — Thu, 10 Jun 2021 14:47:03 GMT