Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
Syndicate_Admin
Administrator
Administrator

RECUENTO DE VALORES REPETIDOS

Hola a todos

Tengo un dato como este.

Nombrede Clientemóvilnúmero de identificación personaláreaTalukciudadestadopaís
AmbArish6360302377562104PeresandraChik BallapurChikkaballapurKarnatakaIndia
Empresas de Shreyas6360339767560040Vijayanagar (Bangalore)Bangalore NorteBangaloreKarnatakaIndia
Empresas de Shreyas6360339767560040Vijayanagar (Bangalore)Bangalore NorteBangaloreKarnatakaIndia
Gotham6360432337572216Nagasandra-gubbiGubbiTumkurKarnatakaIndia
EQUITACIÓN DEL REY6360700489577204Mercado APMC-ShimogaShimogaShimogaKarnatakaIndia
bheerappa h legal6360777275587115BhagavatiBagalkotBagalkotKarnatakaIndia
OBRAS DE INGENIERÍA6361096519577401SagarSagarShimogaKarnatakaIndia
OBRAS DE INGENIERÍA R.S6361096519577401SagarSagarShimogaKarnatakaIndia
m b pendiente6361400636587111KirsurBagalkotBagalkotKarnatakaIndia
NECESITO EL SIGUIENTE RESULTADO
TOTAL DE CLIENTES9 (BASADO EN EL RECUENTO MÓVIL)
CLIENTES REPETIDOS2(BASADO EN EL RECUENTO MÓVIL)

Necesito calcular los clientes repetidos en función de los números de teléfono móvil. Si una o más veces se repite un número de móvil, necesito el recuento como 1 solamente.

Gracias de antemano.

saludos

SRK

1 ACCEPTED SOLUTION
Syndicate_Admin
Administrator
Administrator

@srkase

pls probar esto

total customers = COUNTROWS('Table')

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

1.PNG

View solution in original post

1 REPLY 1
Syndicate_Admin
Administrator
Administrator

@srkase

pls probar esto

total customers = COUNTROWS('Table')

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

1.PNG

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Power BI Header Change

Power BI Header Update

Read about the exciting updates for the Power BI forum.

Top Solution Authors
Top Kudoed Authors