Counting a column after splitting by delimiters

[ld17]

I have a column with some (but not all) values that are split by commas, and I want to split them by delimiter. My goal is to put these in a chart where they are recognized as distinct values. For example, the value "hand, finger" would be broken into two separate values when I split them by delimiter. However, I need help figuring out how to count them as distinct values without "duplicating" the rest of my data. I only want the values in this one column to be counted as many times as needed, but I don't want the rest of my data to be duplicated once this one column is split by delimiter. Thanks in advance!

[ld17]

Thanks, all. The solution ended up being to create another table, import my data again, delete all columns except the one I needed, and then create a relationship between the new table and the original table.

[Anonymous]

Hi @ld17 ,

Sorry for that the information you have provided is not making the problem clear to me.
Please provide me with more details about your table and your problem or share me with your pbix file after removing sensitive data.

Refer to:

How to Get Your Question Answered Quickly - Microsoft Power BI Community

How to provide sample data in the Power BI Forum - Microsoft Power BI Community

Best Regards,
Eyelyn Qin

[Nathaniel_C · Accepted solution]

Hi @ld17 ,
Would you please give us a picture of expected outcome? You can just dummy it up in Excel. and tell us what you would want the count to be.
If you would share your pbix, or dummy up some values in Excel both for current and expected data. Please copy and paste them into your post, rather than doing a picture, we may be able to help you. 

Please read this post to get your question answered more quickly:

https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

Nathaniel