DAX to count a word in a row

[gmazza76]

Good afternoon,

I am trying to count how many times the "MODEL" appears in a string of data in my PowerPivot table.

How would be best to do this as I would expect the count for Model below to be 2, but I am unsure how to formulate this.
Can I add calculate to a search formula or whats the best way to move with this?

CS:20210412000000514,00001535020000034111,13835049,XXXX,Area,Brand,MODEL,,,,BoughtDate,area,Brand,MODEL,;

thanks in advance
Gavin

 

[Bo_Ry]

Try this
=LEN(SUBSTITUTE([Data],"MODEL","MODEL0"))-LEN([Data])

where [Data] is the column Name.