Number of duplicate text in one column

[yellow_days]

Hi,

I have a column with with a text. Some of the text is duplicate which I would like to count (I wanna see how ofter it appears)

I tried following Dax Code, but it doesnt work because it cant compare between text and integer:

AA = COUNTROWS(
FILTER( DISTINCT( TABLE[Text]);
Tabe[Text] >=2
)
)

Does someone know how I could found duplicate text rows?

best regards

[Ashish_Mathur]

Hi,

Drag the text to the row labels of a Table visual and then use this measure

=COUNTROWS(Data)

Hope this helps.

[Anonymous · Accepted solution]

Hi @yellow_days,

You can create a new column using DAX, with the number of occurrences of the texts in the column, using this formula:

Count_occurence =
COUNTX ( FILTER ( Table; EARLIER ( Table[Text] ) = Table[Text] ); Table[Text] )

Regards.

[yellow_days]

Thanks alot!

it works, but without "Earlier()"