Forum Discussion

srkase's avatar
srkase
Icon for Helper IV rankHelper IV
5 years ago
Solved

COUNT OF REPEATED VALUES

Hi all,   I have a data like this. CustomerName Mobile Pincode Area Taluk City State Country AmbArish 6360302377 562104 Peresandra Chik Ballapur Chikkaballapur Karnataka India ...
Need Help
  • ryan_mayu's avatar
    ryan_mayu
    5 years ago

    srkase 

    pls try this

    total customers = COUNTROWS('Table')

repeated customers = 
VAR tbl=SUMMARIZE('Table','Table'[Mobile],"No.",COUNTROWS('Table'))
return countrows(FILTER(tbl,[No.]>1))

ryan_mayu's avatar
ryan_mayu
Icon for Super User rankSuper User
5 years ago

srkase 

pls try this

total customers = COUNTROWS('Table')

repeated customers = 
VAR tbl=SUMMARIZE('Table','Table'[Mobile],"No.",COUNTROWS('Table'))
return countrows(FILTER(tbl,[No.]>1))