Count of Filtered Counts

[thomas_pike]

Good Evening,

I'm trying to write a DAX expression that counts the number of IDs that occur twice or more in a table.

For instance:

ID

A

B

C

A

B

A

...should return 2 as both A and B occur twice or more in the column.  Thanks for your assistance.

[CNENFRNL]

=
COUNTROWS(
    FILTER( VALUES( DATA[ID] ), CALCULATE( COUNTROWS( DATA ) ) > 1 )
)

[ManguilibeKAO]

Hi,

You can use this measure:

Mesm=
Var t = SUMMARIZE('Table','ID',"Cnt",CountRows('Table'))

Return

 CountRows(FILTER(t,[Cnt] >=2))

And, after creating the measure, you can use a card and drag ( or dispaly) the measure on the card, and you'll see the count you are looking for.

Best regards. 

[Anonymous]

Hello

Try this

Countdoubleormore = countrows(filter(summarize('Table','Table'[id],"@nb",COUNTA('Table'[id])),[@nb]>1))

measure