Pinpointing a User to a specific task

[Bmejia]

• I am working with historical data and need to find total items created when there is no relationship with each work item.
  One Ticket is submitted by Group1. 
• Then the system assigns this ticket as a created item to everyone in Group2.  It does not mean they all actually work on it. They system just stamps everyone in the data as created.
• There are different levels within the ticket where Items can be created.
• In my example there were 2 items created in my ticket.  The issue I am having is identifying who created the work item.  I have tried summarizing the data in a new table but that just gives me a single created item.

Any help will be appreciated.

ID	Group	User	Level1	Work Item	Creation Date
10	Group1	AcctUser3		Submission	1/2/2021
10	Group2	Srvsuser1	Level1	Created	1/2/2021	Auto Assign
10	Group2	Svsuser2	Level1	Created	1/3/2021	Auto Assign
10	Group2	Svsuser3	Level1	Created	1/3/2021	Auto Assign
10	Group2	Srvsuser1	level2	Created	1/2/2021	Auto Assign
10	Group2	Svsuser2	level2	Created	1/3/2021	Auto Assign
10	Group2	Svsuser3	level2	Created	1/3/2021	Auto Assign
10	Group2	Svsuser1	Level1	Rejected	1/4/2021
10	Group2	SvsUser3	Level2	Completed	1/3/2021
10	Group2	Svsuser1	Level1	Approved	1/5/2021

What I am looking to build in Matrix or table

Group	Submission	User (Submission)	Created	User(Created)	Rejected	Completed	User(Completed	Approved	User(Approved
10	1/2/2021	AcctUser3	1/2/2021	Svsuser1	1/4/2021			1/5/2021
10	1/2/2021	AcctUser3	1/3/2021			1/3/2021	SvsUser3

I have also created a main key using the ID and users who approved, completed, or rejected but that only gives me the created items for those statuses.  I miss counting the one's that have not gone through thosse statuses.  

AllStatus = Calculatetable(

SUMMARIZE(AllWorkflow,

'AllWorkflow'[ID],

'AllWorkflow'[Level],

AllWorkflow[WorkItem],

AllWorkflow[CreatedDate,

AllWorkflow[User]),

WORKFLOWDETAIL[Tracking Type]="Approval" || WORKFLOWDETAIL[Tracking Type]="Completion",WORKFLOWDETAIL[Approver/CompletionName]<>blank())

What I have tried to do only give me one value

CALCULATETABLE((

SUMMARIZE(

AllWorkFlow,Allworkflow[ID],

"Submission",[Submission],

"Creation",[Creation],

"Rejection",[Rejection],

"Completion",[Completion],

"Approval",[Approval],

"Return",[Return]

)))

[Bmejia · Accepted solution]

Thank you for trying to assist.  I believe i have sore of fixed the issue.  I have created a primary key column using the ID-Level-WorkItem-User.   Then looking at my rejected, completed or approved items and tide it back to the created user.  It is not a perfect solution I am trying to see find a relational table in our system as I can believe one was not build to associate all the actions.  Thanks again!

[Anonymous]

Hi @Bmejia ,

Can you describe the logic, I really can't connect the table above with the result below.

Best Regards,

Jay