Count repeated ids

[emionline]

Hello,

I wonder how I could get a measure that counts the number of IDs that are repeated more than 3 times.

For example, I have a table like this:

ID, Value, X

A, 20, 200

B, 10,500

A, 10, 300

A, 40, 50

B, 10, 30

A, 60, 80

In this example, the result should be 1

How could this be possible?

[Arul · Accepted solution]

@emionline ,

Check if it is working or not,

Count of  More than 3 ID = 
VAR _temptable = SUMMARIZE(
    'Table (4)','Table (4)'[ID],"@Count",COUNT('Table (4)'[ID]))
VAR _result = COUNTX(
    FILTER(_temptable,[@Count]>3),[ID])
RETURN _result

Thanks,

Arul

[emionline]

yes, perfect, thanks