take data of selected month

[Anonymous]

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

[tamerj1 · Accepted solution]

Hi @Anonymous 
Please try

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

[Anonymous]

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 

[tamerj1]

@Anonymous 

Do you have a date table?