How to prepare data when there are multiple items in 1 field

 You want your SalesTable look like this:

1. Use Query Editor to re-format your source data.  Steps:

- Split Colums by Delimiter /

- Split Columns by Delimiter ,

- Unpivot the last 3 columns (with Items)

- Adjust Data Type, etc

2. Add a measure 

Count Items = COUNTROWS(SalesTable)

3. Visualize with Matrix or other chart 

Anonymous,

By the way, you may select Split into Rows directly.