Count of multiple rows

Hi abhishek_2025 ,

Thank you for reaching out to Microsoft Fabric Community.

To create the skill set matrix with accurate counts and employee names, here's how you can structure your Power BI process:

Steps to be followed in power query editor

Unpivot the Employee Columns: 

Select the columns EMP1, EMP2, and EMP3.

Right-click and choose Unpivot Columns. This will create two columns: like below

Extract the text before the parentheses (e.g., "Intermediate", "Expert") into a new column using Power Query’s Split Column by Delimiter option ( (delimiter).

Rename this column to Skill Level just like below

Close and apply to load the data

I have included two visuals: a matrix and a table, along with a graphical representation.

Did I answer your question? Mark my post as a solution!