COUNT WITHIN A CELL

[baBI123]

Hello BI community, 

I was wondering if anyone could help me out with COUNTing the number of itms in a cell within a column. 
see attached pic

For example, I need a new colum that would read 

PO COUNT
3
1
10
3
1
1

Thanks in advance!

[Greg_Deckler · Accepted solution]

The trick to this is using SUBSTITUTE:

Column = LEN([PO list]) - LEN(SUBSTITUTE([PO list],",","")) + 1

[baBI123]

THANK YOU @Greg_Deckler!! That worked perfectly!