Wildcard or "Contains" option in Filter Measure

[StuartSmith]

I currently have the below code that will only calculate values that are "Yes"

Var All_Yes = CALCULATE(COUNT('Services'[Category]),FILTER(ALL('Services'),'Services'[Category]=MAX('Services'[Category])&&'Services'[Status]="Yes"))

I now need it to take into account all values containing "Yes". I tried serching for wildcards, SEARCH, FIND, etc. but couldnt find any information that helps me and therefore calling on your knowledge.  

[StuartSmith · Accepted solution]

Well, I think he found out... adding "CONTAINSSTRING"

Var All_Yes ? CALCULATE(COUNT('Services'[Category]),FILTER(ALL('Services'),'Services'[Category]-MAX('Services'[Category])&&CONTAINSSTRING('Services'[Status],"Yes")))

Just check that the figures are correct.

[v-jingzhang]

Hi @StuartSmith , glad that you have solved this problem by yourself, you may accept your post as a solution to close this topic thus others will find it quickly. Thanks a lot.

Best Regards,
Community Support Team _ Jing Zhang