Identify multiple keywords in a comma separated string.

[ChrisElu]

I have a variable within a measure that returns a comma separated string, e.g., "No,Yes,Yes,N/A,No"

Using this variable, I'm trying to make the measure display the string 'Yes' if there are only Yes values, 'No' if there are only No values, 'Both' if there are both values, and 'N/A' if there are no values or if it's N/A.

I've tried using both the SUBSTITUTE and the CONTAINSSTRINGEXACT functions but it does not seem to be doing what I was hoping for.

Thank you.

[Ashish_Mathur]

Hi,

Share some data to work with and show the expected result.

[FreemanZ]

hi @ChrisElu 

could you paste your code for the measure?