topic Re: Repeats of a value in a column in DAX Commands and Tips

Repeats of a value in a column

Altiano — Fri, 27 Aug 2021 09:27:12 GMT

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

Re: Repeats of a value in a column

amitchandak — Fri, 27 Aug 2021 10:38:48 GMT

Altiano , Create a new column

State name = "State " & [state]

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

Re: Repeats of a value in a column

Jihwan_Kim — Fri, 27 Aug 2021 11:36:47 GMT

State Count : =

COUNTROWS(Data)

Link to the pbix file