Using countif to count numbers of same line value without any desagregation

[marteodori]

Hi everybody, 

I'm trying with the next formula to count when how many lines has the same value in the key figure [Numero Reserva] without any desegregation, but doens't work. Any suggestion?

 'count({<[Numero Reserva]={only([Numero Reserva])}>}[Numero Reserva])'

Thanks!

[Taoufiq_Zarra]

if you mean how many [Numero Reserva] are duplicated

one solution :

=count({<[Numero Reserva]={"=count([Numero Reserva])>1"}>}distinct [Numero Reserva])

output :

for the folow input :

Data:
load * inline [
Numero Reserva
1
1
2
2
3
3
4
5
6
7
8
9
4
];

the output is :

duplicated [Numero Reserva]: 1,2,3,4=4