Reply
avatar user
Anonymous
Not applicable

take data of selected month

Hello I have mobile number reflecting multiple times in different month , i want to have counts of duplication of mobile number of selected month 
for eg if i select Jan 23 it should show counts only for jan Jan23

Prajakta11_0-1676979291534.png

 

 

1 ACCEPTED SOLUTION
tamerj1
Super User
Super User

Hi @Anonymous 
Please try

=
SUMX (
    VALUES ( 'Table'[phone] ),
    VAR CountDuplicate =
        COUNTROWS ( CALCULATETABLE ( 'Table' ) )
    RETURN
        IF ( CountDuplicate = 2, CountDuplicate )
)

View solution in original post

3 REPLIES 3
tamerj1
Super User
Super User

Hi @Anonymous 
Please try

=
SUMX (
    VALUES ( 'Table'[phone] ),
    VAR CountDuplicate =
        COUNTROWS ( CALCULATETABLE ( 'Table' ) )
    RETURN
        IF ( CountDuplicate = 2, CountDuplicate )
)
avatar user
Anonymous
Not applicable

Thak you for your help @tamerj1 ,addition to this i want to show duplication in next 90 days ,what will be the measure for that ,for eg, if i select april , i want to show duplication in april may and june 

 

@Anonymous 

Do you have a date table?

avatar user

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

ArunFabCon

Microsoft Fabric Community Conference 2025

Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)