How to count Occurence of a word in string in a Column, including duplicates

[Musili_Adebayo]

This attached skills screen shot is a data I got from scrapping a Job website. I want to count the skills individually like this and have them splitted. I have done this before in python with tokenisation, However, i am can't replicate the same with DAX.  I am still learning DAX i will appreciate if anyone can help me with it.

I will prefer the answer to be like this:

[ibarrau · Accepted solution]

Hi. You can do it in two ways, but only one is dynamic.

1. Creating a measure for each Skill counting values when CONTAINSSTRING matches the skill. (non dynamic)

2. Go to Power Query editor and transform the table. You need to Split the skill column into rows. (be aware that this will duplicate the rows for each skill). Pay attention if you are using this table for something else to build a copy or do it in the original one. Once you have that it would be an easy visual to build. Just drag the skills column and count. More details here: https://sfmagazine.com/post-entry/november-2017-excel-split-delimited-data-into-new-rows/

I hope that helps,

[Greg_Deckler]

@Musili_Adebayo You can split the column on the / charater in Power Query Editor and then unpivot the resulting columns.