Forum Discussion

Hamdan1234's avatar
Hamdan1234
Helper III
4 years ago
Solved

Distinct count except once repeating once

Hello,

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

NamesSales
James234
Jon567
Ana789
Hales234
Jon511.5
Hales234
Hales280.5
Jon246
Hales211.5

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

Thanks

Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    4 years ago

    Hamdan1234 Maybe:

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

1 Reply

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    4 years ago

    Hamdan1234 Maybe:

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