powerbi - How do we add custom rows using in power bi based on specific string in a column

Question

Need suggestions how do we create rows to existing table which is pulled in Power BI through direct query. For instance I have Emp Table with a Column which contains coma separated activities by Students like Reporting,Analysing,Troubleshooting (These are just . I am trying to create a measure to add rows for each activity so that I can display activity matric in Pie Chart.

question from:https://stackoverflow.com/questions/65835062/how-do-we-add-custom-rows-using-in-power-bi-based-on-specific-string-in-a-column

Answer 1

Waitting for answers