Search multiple text in one column

[buzzkoi69]

I'm trying to search multiple text in a column and to categorize it accordingly. 

for

and I'm currently using:

The output should be like below:

PROCEED TO SEMESTER 2 = PROCEED TO SEMESTER

PROCEED TO SEMESTER 2 AND REPEAT FAILED MODULE(S) IN JULY 2018 = PROCEED TO SEMESTER AND TO REPEAT

However using the Calculation its not giving me the right category, help me please...

[v-alq-msft]

Hi, @buzzkoi69 

Based on your description, I created data to reproduce your scenario.

Academic Progress:

You may create a measure as below.

Result = 
var _value = SELECTEDVALUE('Academic Progress'[Recomendation])
return
SWITCH(
    TRUE(),
    CONTAINSSTRINGEXACT(_value,"PROCEED TO SEMESTER")&&CONTAINSSTRINGEXACT(_value,"AND REPEAT"),"PROCEED TO SEMESTER AND TO REPEAT",
    CONTAINSSTRINGEXACT(_value,"TERMINATION"),"TERMINATION",
    CONTAINSSTRINGEXACT(_value,"PROCEED TO SEMESTER")&&NOT(CONTAINSSTRINGEXACT(_value,"TO REPEAT")),"PROCEED TO SEMESTER",
    BLANK()
)

Result:

Best Regards

Allan

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[buzzkoi69]

Hi @v-alq-msft Thank you, will try this solution as well!

[amitchandak · Accepted solution]

is it a measure or a column

The first condition you have to split

Search("Proceed to Semester",[Column],1,0)>0 && Search("To Repeat",[Column],1,0)>0

Change column name and text as per need

[buzzkoi69]

@amitchandak It works! Thank you so much for your help