How to do it...

To implement this recipe, perform the following steps:

1. Create the following column in the R03_Table table:

CountOfItems = 
    VAR __List = 'R03_Table'[List]
    VAR __Length = LEN( __List )
    VAR __Length2 = LEN( SUBSTITUTE( __List , "," , "" ) )
RETURN
    __Length - __Length2 + 1