How do I use a measure to count the number of times ';' appears in column?

[dinosainsburys]

Hi,

I have a table which lists user emails seperated by ';'. For example,

jac.smith@gmail.com; james.smith@yahoo.com; amy.white@gmail.com; jason.smith@gmail.com 

If the DAX is correct, it should count 3. Any ideas? 

[Demert · Accepted solution]

Hi @dinosainsburys ,

You can create a new measure or column in your table with the following code:

 LEN(Table[ColName])-LEN(SUBSTITUTE(Table[ColName],";",""))

To check how many times ; is in the column 

[pankajnamekar25]

Hey Try this measure

CountOfSemicolons =

SUMX (

    'Users',

    LEN ( 'Users'[EmailList] ) - LEN ( SUBSTITUTE ( 'Users'[EmailList], ";", "" ) )

)

Thanks

 Pankaj Namekar | LinkedIn

If this solution helps, please accept it and give a kudos (Like), it would be greatly appreciated.