Distinct Count with value in same table

[victorbetancurt]

Hi everyone.

Beforehand, sorry for my bad english.

I have a table like this ('Table1'):

CODE	STATE
1015	A
1016	A
1017	B
1015	B
1016	B
1017	B
1015	C
1015	A
1017	B

I want a solution as optimal as possible. (I'd rather calculate with a Power Query function, not DAX).
I want a function (or formula, whatever) that helps me to count every different state for each row with the same code.

My result should be this:

CODE	STATE	RESULT
1015	A	3
1016	A	2
1017	B	1
1015	B	3
1016	B	2
1017	B	1
1015	C	3
1015	A	3
1017	B	1

I explain the result: For code 1015 is 3 because there are 3 unique values for 1015 (A,B,C). For code 1016 is 2 there are 2 unique values (A,B). For code 1017 is 1 because there are 1 unque value for 1017 (B).