Repeats of a value in a column

[Altiano]

Hi everyone

I have a question that I think should be easy but I can't solve it 
I have the following table

Id Center State Person
--------- ----- --------
1          1    P1
1          1    P2
1          2    P3
1          3    P4
1          3    P5

I wanted to show for "center 1", how many times appears "state 1", "state 2", ......
that is to say

"Center Id" "State 1" "State 2" "State 3"
-----------------------------------------
1             2        1          2

How can I solve it?

Thanks in advance

[Jihwan_Kim]

State Count : =

COUNTROWS(Data)

Link to the pbix file 

[amitchandak]

@Altiano , Create a new column

State name  = "State " & [state]

Put this on a column of Matrix and take count of state on values