Jira Dashboard (Created vs Resolved)

Hi Anonymous ,

Sorry for replying late. Seems like you need a Date table first, create a calculated table like this:

Calendar = CALENDARAUTO()

Create realationships between the Date table and your source table:

resolve-date is active, created-date is inactive

Create measures like this:

Resolved number = 
COUNTX (
    FILTER (
        'Table',
        'Table'[Created] <> BLANK ()
            && 'Table'[Resolved] <> BLANK ()
    ),
    [Key]
)

Unresolved number = 
CALCULATE (
    COUNT ( 'Table'[Key] ),
    'Table'[Resolved] = BLANK (),
    USERELATIONSHIP ( 'Table'[Created], 'Calendar'[Date] )
)

Add the filter conditions as your needed.

Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.