please help me find Duplicates

HI sharonmathew

Please could you give me an example of OUTPUT desired.

I will try to help.

Ok, thanks, but perhaps, my query, needs a bit rephrasing, as i might not have been explained that part.

when i pull one field, all the fields to be applied in the measure without all the fields being pulled.

the measure you have given me does work like charm,  i do not have any disagreement. 

but please give me a measure which would give me the even when we put one of the fields in the row label.

with all the fields being considered.

so if we place Airline field. then it calculates the duplicates considering all the fields in the data table. [but there may bemore fields which we need not consider for this calculation] it gives me the all the entries of duplicates. just as a data table sorted with duplicate entries.

ok, if we place Airline [ or any of the fields which is shown on the data table]

we get a table with measure tells us each row by row which is 1st entry and 2nd entry and 3rd entry.

so here i dont necessarily have to pull all the fields [

result looks like this.

or