make a column that counts number of values equal the value of the same row

[glauberdmo]

I saw another post that counts a especific value: 

ColumnName1 = CALCULATE ( COUNTROWS (Table 1), Table 1[fieldName] = "Value")

I don't want to choose a constant value, I'd like to build a column that counts using a value from a column. Example:

Colors    Count

Blue         3

Blue         3

Blue         3

Yellow     2

Yello       2

How to parse the Color column? 

[Vvelarde · Accepted solution]

@glauberdmo

Hi. Use a new calculated column with this Code:

Column =
COUNTROWS ( FILTER ( Table1, Table1[Color] = EARLIER ( Table1[Color] ) ) )

[glauberdmo]

That "EARLIER" function is what I need! Thank you! Marked as answered.