Cannot compare Text with List in ([Referral Source] = [_thisrow].[Referral Source])

[GavinDJ]

Hi there,

I keep getting the same error with both Select and lookup.

Here's the expression that I'm trying to use:

lookup(
[_thisrow].[Referral Source],
"Referrals",
"Referral Source",
"Image")

[_thisrow].[Referral Source] is an Enumlist. 

"Referral Source" is a static list and I want to return the image location under "image".

Can anyone help?  Thanks in advance.

[Markus_Malessa]

What is the error you are getting? I suspect however that you are trying to compare a LIST type column to a TEXT type column.

[Markus_Malessa · Accepted solution]

Possibly one of these two solutions should do:

LOOKUP(ANY([_THISROW].[Referral Source]), "Referrals", "Referral Source", "Image")

SELECT(Referral Source[Image], IN([Referrals], [_THISROW].[Referral Source]))