undefined

[Eng-mohd]

I have number of id's and i wana count how many id call twice or more

Ex

1000 customer 

800 call mor than 1 

200 call only 1

I wana found number 800

The column have number 

[Dangar332 · Accepted solution]

Hi, @Eng-mohd 

try below

measure =
var a = ADDCOLUMNS(
          ALL('Table (5)'[id]),
         "count",CALCULATE(
                     IF(COUNT('Table (5)'[id])>1,1,0)
                 )
        )
return
SUMX(a,[count])

here my data 

out put according to data