topic Re: SEARCH FUNCTION WITH A LIST VALUE COMMAS in DAX Commands and Tips

SEARCH FUNCTION WITH A LIST VALUE COMMAS

Anonymous — Wed, 30 Mar 2022 16:05:16 GMT

Hi guys,

I found answer for that : we have 2 lists. Now we want to check if list 1 contains any value from list 2.

which values in list are in current value? =

CONCATENATEX (

CALCULATETABLE (

VALUES ( List[Keyword] ),

FILTER ( List, SEARCH ( List[Keyword], 'Messy names'[Name], 1, 0 ) > 0 )

[Keyword],

","

)

My question is how to display which values in list are NOT in current value? Any idea please ?

tamerj1 — Wed, 30 Mar 2022 16:51:34 GMT

Hi Anonymous

nice code. Well done 👍. I think you just need to replac > with =

CONCATENATEX (

CALCULATETABLE (

VALUES ( List[Keyword] ),

FILTER ( List, SEARCH ( List[Keyword], 'Messy names'[Name], 1, 0 ) = 0 )

[Keyword],

","

)

Anonymous — Wed, 30 Mar 2022 16:57:30 GMT

Works.... 🙊 Thank You so much for that.