COUNT OF REPEATED VALUES

[srkase]

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
Shreyas enterprises	6360339767	560040	Vijayanagar (Bangalore)	Bangalore North	Bangalore	Karnataka	India
Shreyas enterprises	6360339767	560040	Vijayanagar (Bangalore)	Bangalore North	Bangalore	Karnataka	India
Gotham	6360432337	572216	Nagasandra-gubbi	Gubbi	Tumkur	Karnataka	India
RAJA NAIK	6360700489	577204	Marketyard APMC-Shimoga	Shimoga	Shimoga	Karnataka	India
bheerappa h jogi	6360777275	587115	Bhagavati	Bagalkot	Bagalkot	Karnataka	India
R S ENGINEERING WORKS	6361096519	577401	Sagar	Sagar	Shimoga	Karnataka	India
R.S ENGINEERING WORKS	6361096519	577401	Sagar	Sagar	Shimoga	Karnataka	India
m b hallur	6361400636	587111	Kirsur	Bagalkot	Bagalkot	Karnataka	India
I NEED THE FOLLOWING RESULT
TOTAL CUSTOMERS	9	( BASED ON MOBILE COUNT)
REPEATED CUSTOMERS	2	( 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

[ryan_mayu · Accepted solution]

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