http://powerpivotforum.com.au/viewtopic.php?f=6&t=1055Kindly hlp me identify the duplicates.

Hi sharonmathew You can add this calculated column to your Table = IF ( CALCULATE ( COUNTROWS ( TableName ) ) > 1, "Duplicates" )

sharonmathew As a MEASURE, try this = IF ( COUNTROWS ( TableName ) > 1, COUNTROWS ( TableName ) )

sharonmathew MEASURE are dynamic.... SO whatever combination of fields you use in a PIVOT TABLE..... This MEASURE would give you the count of duplciates for that

HI sharonmathew Please could you give me an example of OUTPUT desired. I will try to help.

Forum Discussion

sharonmathew

Helper I

8 years ago

please help me find Duplicates

http://powerpivotforum.com.au/viewtopic.php?f=6&t=1055

Kindly hlp me identify the duplicates.

Need Help

10 Replies

Zubair_Muhammad
Community Champion
8 years ago
Hi sharonmathew

You can add this calculated column to your Table

= IF ( CALCULATE ( COUNTROWS ( TableName ) ) > 1, "Duplicates" )
- Zubair_Muhammad
  Community Champion
  8 years ago
  sharonmathew
  - sharonmathew
    Helper I
    8 years ago
    Hi thanks,
    
    but can we get a measure:=,
    
    it is attractive than cc.. i love measures.

Forum Discussion

please help me find Duplicates

10 Replies

Related content

Duplicate ranking

remove duplicate value within a row

Removing Duplicates

Help Please

Identifying duplicates