Item Count within a Cell

[Anonymous]

I am trying to count the number of items in a column that are seperated by comma delimiter. My DAX calculated column will not yield the correct item count. Where am I going wrong? 

Current DAX ->

Site Machine Count = LEN(MW2_WEDM[machine_list]) - LEN(SUBSTITUTE(MW2_WEDM[machine_list],",","")) + 1

Please reference the screenshot below. The resulting output is not getting the right count.

- EX: 3rd Dimension LLC -> machine_list = 2 items (Expected output count = 2 / My results = 3)

I found this previous post which is the exact same as the task I am trying to complete so I copied the syntax but am not getting the anticipated output needed. (https://community.powerbi.com/t5/Desktop/COUNT-WITHIN-A-CELL/m-p/319348#M142105) 

Any guidance will be greatly appreicated!

 

[Greg_Deckler · Accepted solution]

I created a Quick Measure for that: https://community.powerbi.com/t5/Quick-Measures-Gallery/Count-of-List-Items/m-p/350084

I think the difference might be your trailing commas so maybe lose the +1

[Anonymous]

Sir...you are a hero! 

FYI...I tried using the original syntax but removed + 1 and it worked! 

My deepest gratitude for you! Thank you datanaut!