Forum Discussion

Eng-mohd's avatar
Eng-mohd
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's avatar
    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

     

1 Reply

  • Dangar332's avatar
    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