Forum Discussion

Helper I

2 years ago

Solved

undefined

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

Need Help

Dangar332

2 years ago

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

Dangar332

Resident Rockstar

2 years ago

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