DAX search in column and retuen a result

[Anonymous]

Hi,

I am rying to create a measure that looks in to a column and if the column includes the value than true

ie

new measure = columnA include/has 'TWO' . Two could be in a sentence with 10 to 20 words

id       ColumnA

1      one,two,three,four,five,six.seven

2      one,one,five,six,six,ten

3      six,seven,eight,five,six

      so the new measure should return 1

I hope that make sense

thanks

[v-chuncz-msft]

@Anonymous,

You may try the measure below.

Measure =
VAR s = "TWO"
VAR d = ","
RETURN
    COUNTROWS (
        FILTER ( Table1, SEARCH ( d & s & d, d & Table1[ColumnA] & d, 1, 0 ) > 0 )
    )
    > 0

[Anonymous]

thanks

[Anonymous]

@Sam

thanks for the respond,

I am not sure if I undrestand the " d & s & d, d & Table1[ColumnA] & d, 1, 0 ) > 0 " part  , could you please explain briefly , thanks

[v-chuncz-msft · Accepted solution]

@Anonymous,

Learn the function by links below.

• https://docs.microsoft.com/en-us/dax/search-function-dax
• https://dax.guide/search/

[Anonymous]

Thanks