How to count events in a column with respect to a second column?

[thequirkymind]

Hi,

I have the following table,

Action	Person
Pull	A
Pull	B
Push	A
Sit	C
Pull	B
Sit	B
Pull	A
Push	C

I want to convert this to a Table that counts the number of each actions performed by each person,

The Final Table should look like this,

	Pull	Push	Sit
A	2	1	0
B	2	0	1
C	0	1	1

How can I do this?
Any help is appreciated

[thequirkymind]

Thank you. i appreciate your help

[amitchandak · Accepted solution]

@thequirkymind , Create a matrix visual person on row, Action on column and count of action or person in values

https://docs.microsoft.com/en-us/power-bi/visuals/desktop-matrix-visual