Solved: Re: How to count/calculate number of elements/valu...

EricDeferm · ‎09-15-2017

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 · ‎09-15-2017

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

Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!: Power BI Cookbook Third Edition (Color)

DAX is easy, CALCULATE makes DAX hard...

Greg_Deckler · ‎09-15-2017

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

Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!: Power BI Cookbook Third Edition (Color)

DAX is easy, CALCULATE makes DAX hard...

EricDeferm · ‎09-21-2017

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

This is what makes Power BI so powerful 🙂

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