How to count/calculate number of elements/values seperated by commas in a column

[EricDeferm]

I have a number of columns that contains multiple values/elements. (see picture)

Which function or formula allows me to retrieve the number of elements/members?

[Greg_Deckler · Accepted solution]

Column = VAR originalLength = LEN([Text])
VAR replaceLength = LEN(SUBSTITUTE([Text],",",""))
RETURN originalLength - replaceLength + 1

[EricDeferm]

Sorry for my late replace. Didn't know you could define vars in a column definition.

This is what makes Power BI so powerful 🙂