Forum Discussion
Anonymous
8 years agoNot applicable
Counting rows, with a filter if something contains certain text, not exact text
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!
Anonymous
May be
Measure = CALCULATE ( COUNT ( Table1[Region] ), SEARCH ( "ANZ", Table1[Region], 1, 0 ) > 0 )
3 Replies
- Zubair_Muhammad
Community Champion
Anonymous
May be
Measure = CALCULATE ( COUNT ( Table1[Region] ), SEARCH ( "ANZ", Table1[Region], 1, 0 ) > 0 )- AnonymousNot applicable
Thank you! This is great.
Could I just ask why the >0 sits at the end (so I understand it all) ?
- goutham_ypRegular VisitorSimple and worked!