COUNTING DUPLICATED VALUES IN A CONSULTATION COLUMN

[aplopes]

Hello people,

I need a way to count how many times a value appears in a given column. This could occur by creating a new column indicating the amount of incidence of the value, as an example of the "duplicity" column in the image below. It could be in M, DAX language or any other form that exists.

Hugs!

[AlB · Accepted solution]

Hi @aplopes 

You can create a calculated column in DAX:

Duplicidade_idbaixa =
CALCULATE ( COUNTROWS ( Table1 ), ALLEXCEPT ( TAble1, Table1[idbaixa] ) )

[aplopes]

Perfect! Thank you!