How to create a measure who count by category in Dax ?

[Anonymous]

Hey everyone, I have my table one, who look like this :

Location	X	Y
Location_1	A	B
Location_1	B	C
Location_2	A	C
Location_4	C	A
...	...	...

I would like to create new column in another table with measure who count of each notes for X and Y By category (which is Location), how can I do that ?

The expected output in the other table:

Location	Rank	Count_X	Count_Y
Location_1	A	56	10
Location_2	A	38	16
Location_3	A	23	63
Location_4	A	12	65
Location_1	B	75	26
Location_2	B	83	37
Location_3	B	94	74
Location_4	B	35	73
Location_1	C	64	15
Location_2	C	194	64
Location_3	C	285	25
Location_4	C	186	241

(All numbers are here for example)

Thanks all for any help !

[Bmejia · Accepted solution]

you can use this  measure to count

Count X = CALCULATE(COUNT(YourTable[YourColumn_X]))

or if you just add the column you want to add to your table/Matrix and right click and select count