Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

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's avatar
    Zubair_Muhammad
    Icon for Community Champion rankCommunity Champion

    Anonymous

     

    May be

     

    Measure =
    CALCULATE (
        COUNT ( Table1[Region] ),
        SEARCH ( "ANZ", Table1[Region], 1, 0 ) > 0
    )
    • Anonymous's avatar
      Anonymous
      Not applicable

      Thank you! This is great.  

       

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