count how many times the value is repeated

[vinicius_ramos]

Hello! 

I need a help to create a new collunm at power BI using DAX. In my example I have a colunm1 with some values that are repeat. I need a collunm that count how many times the value is repeated:

Colunm1	How many times
A	3
A	3
A	3
B	2
B	2
C	4
C	4
C	4
C	4
D	1

Anybody can help me? Thanks a lot.

[Fowmy · Accepted solution]

@vinicius_ramos 

New Col = 
CALCULATE(
    COUNTROWS( TableName),
    ALLEXCEPT( TableName , TableName[Column1] )      
) 

[vinicius_ramos]

@Fowmy 

Thanks !

[ray_codex]

U need context transition:

 CALCULATE(COUNT(Table[Column1]))

This creates a filter on the value in the first column, counting the unique filtered values.