Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Counting Unique Duplicate Email Addresses

Is there a way to count the number of unique email addresses in a column that are duplicated?   I want to get the same number as Excel when you remove duplicates; e.g. 114 duplicates were removed. ...
Need Help
Tips and Tricks
  • az38's avatar
    az38
    6 years ago

    Hi Anonymous 

    If you need distinct count of duplicated rows, try a measure

    Measure = COUNTROWS(
FILTER(
SUMMARIZE('Table', 'Table'[Column1], "Count", COUNT('Table'[Column1])),
[Count] > 1
)
)
az38's avatar
az38
Community Champion
6 years ago

Hi Anonymous 

If you need distinct count of duplicated rows, try a measure

Measure = COUNTROWS(
FILTER(
SUMMARIZE('Table', 'Table'[Column1], "Count", COUNT('Table'[Column1])),
[Count] > 1
)
)