Count number of tasks for each employee based on status

[Haya]

Dears, I have the following Data that shows employee task assignment and I would like to know for each employee, the number of in progress task, the number of completed task, the number of not started tasks.

Example of my data

Title	Assigned to	status
Task 1	Haya, Sara	In progress
Task 2	Sara	Completed
Task 3	Haya, Sara, Fahad, Ameen	Not Started
Task 4	Ameen, Fahad, dalal	In Progess

My required table

Name	In Progress Tasks	Not Started Tasks	Completed Tasks
Sara	1	1	1
Haya	1	1	0
Fahad	1	1	0
Ameen	1	1	0
Dalal	1	0	0

The first issue that I've faced that I need to split (Assigned To) colom to rows based on delimeter. then, I've tried the following expression but the output was wrong

count = COUNTROWS(FILTER('Table','Table'[Status]="In Progress" && 'Table'[Assigned to]='Table'[Assigned to] ))

[amitchandak]

First, do data transformation/edit queries. There is an option to split column and convert to rows

https://community.powerbi.com/t5/Desktop/How-to-split-the-the-Column-into-Multiple-rows/td-p/253361

https://www.pbiusergroup.com/communities/community-home/digestviewer/viewthread?GroupId=547&MessageK...

Once this is done you can easily calculate three measures.

Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution.
In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blogs -Decoding Direct Query - Time Intelligence, Winner Coloring on MAP, HR Analytics, Power BI Working with Non-Standard TimeAnd Comparing Data Across Date Ranges
Connect on Linkedin

[MFelix · Accepted solution]

Hi @Haya ,

You need to go to the query editor and split by delimiter option for the Assigned to column and then select the advance and choose the rows, this will give you a line per each user.

Then you just need to place the values in a matrix visualization with the following format:

• Rows: Assigned to
• Columns: Status
• Values: Status (Count)

Check PBIX file attach.

[Haya]

Thanks a lot @MFelix 

Now I have two tables, one for each project.

I want to show the same requried table but for the two projects combined.

How can I do it?