cancel
Showing results for
Did you mean:
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
Super User III

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
Super User III

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)

Super User I

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.

Proud to be a Super User!

Announcements