Forum Discussion

srkase's avatar
srkase
Helper IV
5 years ago
Solved

COUNT OF REPEATED VALUES

Hi all,

 

I have a data like this.

CustomerNameMobilePincodeAreaTalukCityStateCountry
AmbArish6360302377562104PeresandraChik BallapurChikkaballapurKarnatakaIndia
Shreyas enterprises6360339767560040Vijayanagar (Bangalore)Bangalore NorthBangaloreKarnatakaIndia
Shreyas enterprises6360339767560040Vijayanagar (Bangalore)Bangalore NorthBangaloreKarnatakaIndia
Gotham6360432337572216Nagasandra-gubbiGubbiTumkurKarnatakaIndia
RAJA NAIK6360700489577204Marketyard APMC-ShimogaShimogaShimogaKarnatakaIndia
bheerappa h jogi6360777275587115BhagavatiBagalkotBagalkotKarnatakaIndia
R S ENGINEERING WORKS6361096519577401SagarSagarShimogaKarnatakaIndia
R.S ENGINEERING WORKS6361096519577401SagarSagarShimogaKarnatakaIndia
m b hallur6361400636587111KirsurBagalkotBagalkotKarnatakaIndia
        
I NEED THE FOLLOWING RESULT      
        
TOTAL CUSTOMERS9 ( BASED ON MOBILE COUNT)    
REPEATED CUSTOMERS2( BASED ON MOBILE COUNT)    

 

I need to calculate the repeated customers based on mobile numbers.  If one or more time a mobile number is repeated, i need the count as 1 only.  

 

Thanks in advance.

 

Regards

SRK

 

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

1 Reply

  • ryan_mayu's avatar
    ryan_mayu
    Super 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))