Distinct count except once repeating once

[Hamdan1234]

Hello,

I want to distinct count the names for just thoese which are repeating more that one time. My data look like below.

Names	Sales
James	234
Jon	567
Ana	789
Hales	234
Jon	511.5
Hales	234
Hales	280.5
Jon	246
Hales	211.5

My outcome would be 2 as Jon and Hales are the only one repeating more than once. Please help.

Thanks

[Greg_Deckler · Accepted solution]

@Hamdan1234 Maybe:

Meaure =
  VAR __Table = SUMMARIZE('Table',[Names],"__Count",COUNTROWS('Table'))
RETURN
  COUNTROWS(DISTINCT(FILTER(__Table,[__Count]>1)))