Splitting values spearated by semi-colons, then grouping them

[Rach01]

I have data that exists in a single column, but the data is separated by semi colon, I could visualize the data, however, I don't want to show the number of records for the combination of values, I want to show the # of results for each value. I want to show the # of results per keyword, not the # of results per the combination of this keyword with others. My visualization looks like this: 

[mwegener]

Hi @Rach01,

is your problem solved?
If I answered your question, please mark my post as solution, this will also help others.
Please give Kudos for support.

[V-lianl-msft]

Hi @Rach01 ,

Could you please share sample data and expected results?(Please mask any sensitive data before uploading)

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[mwegener]

Hi @Rach01 

use Split Column By Delimiter...

... and Split into Rows

Regards,

Marcus

Dortmund - Germany
If I answered your question, please mark my post as solution, this will also help others.
Please give Kudos for support.

[Rach01]

@mwegener Thanks for your reply. The issue here is it will make a separate row for each entry, which will duplicate other data in other columns. So if I have another tab in my report to get # of records for a specific value in another column, it will show wrong data. 

How can we do this? 

[Ashish_Mathur]

Hi,

Splitting data by rows is the only way to get your desired visual.  To count unique values thereafter, use the DISTINCTCOUNT() function.

[mwegener]

Hi @Rach01 ,

try to create a "filter" table and link it with a many-to-many relationship.

Regards,

Marcus

Dortmund - Germany
If I answered your question, please mark my post as solution, this will also help others.
Please give Kudos for support.