Need help in DAX

[Anonymous]

Name	Skills
Mahesh	Power BI, Cognos, Tableau
Saravan	Tableau, Cognos
Raju	Power BI, MSBI
Nagesh	MSBI, Tableau
Ravi	Tableau, Power BI

Requirement is to know get the number of users having the each skill Power BI , Tableau, MSBI, Cognos. Need to be shown data in bar char or Pie chart

[v-eachen-msft]

Hi @Anonymous ,

You could use split the "Skills" column and unpivot new columns in the query editor. 

Then use "trim" to remove blank value.

Here is the result.

Here is my test file for your reference.

[TomMartens · Accepted solution]

Hey @Anonymous ,

here you will find a pbix that contains a solution that does rely on data modeling instead of using DAX: https://tommartens-my.sharepoint.com/:u:/g/personal/tom_minceddata_com/EZ1UYqubNL5OrQP-VIdgBEsBF93buB8kEzbOZhVW35sslA?e=Zj62yj

I created a second table using Power Query that looks like this:

Then I creatd a Many-To-Many relationship between both tables like so:

This data model allows to create the visuals you mentioned:

 Hopefully this provides what you are looking for.

Regards,

Tom

[SivaMani]

@Anonymous,

Please check this DAX function - https://docs.microsoft.com/en-us/dax/containsstring-function-dax