Forum Discussion
Need help in DAX
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
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
3 Replies
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
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.
Anonymous,
Please check this DAX function - https://docs.microsoft.com/en-us/dax/containsstring-function-dax
