Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Count items from a splitted string

Hello,   I have some ideas for my report, but sadly, with my limited capability, I cannot visualize it. I want to count the skills most popular for each department and have a bar chart for that. Th...
tamerj1's avatar
tamerj1
Community Champion
3 years ago

Hi Anonymous 

let's say that you have a disconnected table 'Skills' that contains all the skills. Such filter/slicer table would be required. You can create manually or using dax (let me know if you need help in that). 
now you can create a measure as follows 

Count =
COUNTROWS (
FILTER ( 'Table', CONTAINSSTRING ( 'Table'[Skills], MAX ( Skills[Skills] ) ) )
)

Then place the measure in the y-axis of a stacked bar chart the drag 'Table'[Department] to x-axis and Skills[Skill] into the legend 

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hello,

     

    That would be nice if you would suggest me how to create the Skills table. I am a novive with PowerBI and DAX, so your help is much appreciated.

     

    Also, can I ask why we use MAX(Skills[Skills]) for counting?

    And I do not get the concept of creating measure. How will Power BI process when you stack the measure, skills and department name into such chart?

     

    Thanks a lot!!!!!!!!!!!!!!!!!!!!!

    • tamerj1's avatar
      tamerj1
      Community Champion
      3 years ago

      Anonymous 

      You can manually insert it or just type it in excel and then import it. Please let me know if you're still facing problems.