cancel
Showing results for
Did you mean:
Highlighted
Frequent Visitor

## Counting duplicate entries and displaying it on table

Consider the table below;

I'm looking to create a measure that shows  the duplicate count on count name Id pairs without having to create the intermediate calculated column name Id pairs.

 names ID name - ID Pairs count name - ID pairs smith 1100 smith 1100 2 borke 0012 borke 0012 1 smith 1100 smith 1100 2 travis 1234 travis 1234 1 amadeus 0987 amadeus 0987 1
1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Champion

## Re: Counting duplicate entries and displaying it on table

Create a measure

Duplicates =

var _a = CONCATENATE(MAX('Table'[Name]),MAX('Table'[ID]))

RETURN
COUNTX('Table',_a)

Regards,
Harsh Nathani

Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)

2 REPLIES 2
Highlighted
Solution Specialist

## Re: Counting duplicate entries and displaying it on table

Here you go:

CountPairs =
var __tbl = SUMMARIZE('Table';'Table'[ID];'Table'[names];"c";COUNTROWS('Table'))
return
MINX(__tbl; [c])

As seen here:

File is here.

Please mark as solution if this is what you are looking for. Thumbs up for the effort is appreciated.

Kind regards, Steve.

Highlighted
Community Champion

## Re: Counting duplicate entries and displaying it on table

Create a measure

Duplicates =

var _a = CONCATENATE(MAX('Table'[Name]),MAX('Table'[ID]))

RETURN
COUNTX('Table',_a)

Regards,
Harsh Nathani

Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)

Announcements

#### August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

#### Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

#### Community Summit Australia – Join Online!

Be a part of the leading Microsoft Business Applications digital event, curated for the APAC community.

Top Solution Authors
Top Kudoed Authors