How to create measure that counts number of values separated by commas within a list?

[ak8598]

Hi,

I have a Table that has a column that has a list of values, which I've then separated by a comma (,) delimiter as such through power query:

Column

Malware Spread

Malware Spread,Ransomware

Ransomware,Data Leak

Can I create a quick measure that can count for example the number of 'Malware Spread' values within this column (should count as 2 in this example)?

[amitchandak · Accepted solution]

@ak8598 , You can use search  or containsstring

countrows(filter(Table, containsstring([Column], "Malware Spread") )

CONTAINSSTRING and CONTAINSSTRINGEXACT: https://www.youtube.com/watch?v=XbgLGDvWdWQ&list=PLPaNVDMhUXGaaqV92SBD5X2hk3TMNlHhb&index=44

SEARCH and FIND: https://www.youtube.com/watch?v=mZt0HJw4gjQ&list=PLPaNVDMhUXGaaqV92SBD5X2hk3TMNlHhb&index=45

[ak8598]

Thanks a lot, that worked perfectly!

Cheers.