Measure to check if result from one measure is contained within result from another measure

[Pandadev]

I have two measures that return country names based on max formulas , some of the returned values contain multiple countries , seperated by a comma. so my current measure i am using is not matching any data which has multiple countries as it would not be an exact match.

Example : 

Measure --  Op Country = United States

Measure --  Max Base = Mexcio,United States

so my measure :  

Measure -- Matched Country = If([Op Country]=[Max Base],"Yes","No") , only works if there is just one unique Max Base result

Is there a formula to say if Op Country exist within Max Base , then Yes

[Greg_Deckler]

@Pandadev Yes, you could use FIND, SEARCH or even SUBSTITUTE

[Pandadev]

Thanks , could you please show me an example of how one of these formulas would look 

[v-easonf-msft · Accepted solution]

Hi , @Pandadev 

You can try function CONTAINSSTRING  :

Matched Country = IF(CONTAINSSTRING([M_maxbase],[M_op_country]),"Yes","No")

 The result will show as below:

By the way ,CONTAINSSTRING is not case-sensitive.

Best Regards,
Community Support Team _ Eason
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.