Calendar Date not working with created date and resolved date

Hi Guys,

 I am trying to get total open defect Vs closed defect per day from Source file. Source file has created on date and Resolve date. I want these both dates to behave with calender date.

I have created date table using below code and also created measures for total open defects and closed defect.

I have set relationship of datetable date with created on date on file

another relationship is inactive with resolved date as its not possible.

Now,I am getting open defects correctly but closed defects not working with date.

DateTable =

ADDCOLUMNS (

    CALENDAR (MIN('SourceFile'[Created on Date]), MAX('SourceFile'[Resolved])),

    "Year", YEAR([Date]),

    "Month", FORMAT([Date], "MMMM"),

    "MonthNumber", MONTH([Date]),

    "Weekday", FORMAT([Date], "dddd")

)

Total Closed Defects =

CALCULATE (

    COUNTROWS ('SourceFile'),

    USERELATIONSHIP (DateTable[Date], 'SourceFile'[Resolved])

)  

 

 

Total Open Defects =

CALCULATE (

    COUNTROWS ('SourceFile'),

    FILTER (

        'SourceFile',

        'SourceFile'[Created on Date] <= MAX(DateTable[Date]) &&

        (ISBLANK('SourceFile'[Resolved]) || 'SourceFile'[Resolved] > MAX(DateTable[Date]))

    )

)

Can you please help me to get closed defects to reflect by day. Thanks in advance.