count how many times a word appears in each cell

[Adalapc]

Hi all,

I need to count how many times a word appears in each cell. (are logs of an application)

Ex.:
Text
Doc A Saved, Doc B Error, Doc C Saved, Doc D Attention

I need to count how many times the word "saved" appears, in the example above 2 times.

[Icey]

Hi @Adalapc ,

I modified @az38 's expression:

CountMeasure =
SUMX (
    'Table',
    CALCULATE (
        DIVIDE (
            LEN ( MAX ( 'Table'[Text] ) )
                - LEN ( SUBSTITUTE ( MAX ( 'Table'[Text] ), "Saved", "" ) ),
            LEN ( "Saved" )
        )
    )
)

Best Regards,

Icey

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[az38 · Accepted solution]

Hi @Adalapc 

try this

CountColumn = (len('Table'[Text])-len(substitute('Table'[Text];"Saved";"")))/len("Saved")

you canalso store your replaced word in the new column SavedText and change "Saved" in the formula on 'Table'[SavedText]

[careengov]

Where do we put this?

CountColumn = (len('Table'[Text])-len(substitute('Table'[Text];"Saved";"")))/len("Saved")