Count rows that match a certain string from a column

[Anonymous]

Hi,

I want to count rows that contain a certain value from a long string in a column

Table

id   meta

1    apples_abc_def

2    mangoes_abc_def

Count rows where meta contains apples

How do I write this is dax? I tried search function but it did not work. 

[Zubair_Muhammad · Accepted solution]

=calculate (countrows(tablename), search("apples", tablename[meta],, 0)>0)