Forum Discussion

emionline's avatar
emionline
Frequent Visitor
3 years ago
Solved

Count repeated ids

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?

Need Help
  • Arul's avatar
    Arul
    3 years ago

    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

2 Replies

  • Arul's avatar
    Arul
    Super User
    3 years ago

    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