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...
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

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

emionline's avatar
emionline
Frequent Visitor
3 years ago

yes, perfect, thanks