Counting rows, with a filter if something contains certain text, not exact text

[Anonymous]

Hi all

I'm trying to countrows of a column that contain different regions.  My column looks similar to this: 

[Region]

ANZ

ANZ, Americas

ANZ, EMEA

EMEA, Americas

I want to countrows (presumably will use a filter) but not [Region] = "ANZ" as that won't pick up the ANZ in the other rows.   where it is combined with another region.  What can I use to count the times ANZ appears in the column, regardless of the other values in the cell. 

Thanks!

[Zubair_Muhammad · Accepted solution]

@Anonymous

May be

Measure =
CALCULATE (
    COUNT ( Table1[Region] ),
    SEARCH ( "ANZ", Table1[Region], 1, 0 ) > 0
)

[goutham_yp]

Simple and worked!

[Anonymous]

Thank you! This is great.  

Could I just ask why the >0 sits at the end (so I understand it all) ?