Forum Discussion

megwpost's avatar
megwpost
New Member
6 years ago
Solved

trying to count a string is difficult

I currently am trying to better group open text columns.  my example here is that I first want to group and count any that contain the string "Win 10".  This should be fairly simple to do (it is ...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    Hi megwpost ,

    You can create a calculated column as below and put the new column onto the visual (its total value is the number of strings containing Win 10).

     

    IsexistWin10 = 
VAR _exist =
    IFERROR ( SEARCH ( "Win 10", 'Document'[CoS_ShortSummary] ), 0 )
RETURN
    IF ( _exist > 0, 1, 0 )

     

    Best Regards

    Rena

HotChilli's avatar
HotChilli
Icon for Community Champion rankCommunity Champion
6 years ago

I can start you off.

Add a column with DAX like

ColumnA = FIND("Win 10", Table[Column],,0)
 
sub in the table and column names