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 (...
Tutorial Requests
  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    8 years ago

    Anonymous

     

    May be

     

    Measure =
CALCULATE (
    COUNT ( Table1[Region] ),
    SEARCH ( "ANZ", Table1[Region], 1, 0 ) > 0
)
Zubair_Muhammad's avatar
Zubair_Muhammad
Icon for Community Champion rankCommunity Champion
8 years ago

Anonymous

 

May be

 

Measure =
CALCULATE (
    COUNT ( Table1[Region] ),
    SEARCH ( "ANZ", Table1[Region], 1, 0 ) > 0
)
goutham_yp's avatar
goutham_yp
Regular Visitor
7 years ago
Simple and worked!