How to use filters in a visual but ignore them in a measure used in the visual

[Terrassa]

Hello,

I have a ticketing system to manage IT incidents. Each ticket has a creation and close date (close date can be empty). I need a visual to show how many tickets were created and closed in each month and also how many remain open at the end of each month.

The visual should show only the last 12 months, but to calculate how many tickets are open it must include all the history because we can have tickets still open since more than 12 months ago.

I have this measure to calculare how many tickets are active at the end of each month:

Remaining open =

var created_jiras = calculate(count(Jira[Jira]), filter(allselected(Jira), Jira[Creation date] <= max('Calendar'[Date])))

var closed_jiras = calculate(count(Jira[Jira]), filter(allselected(Jira), Jira[Closed date] <= max('Calendar'[Date]) && Jira[Closed date] <> BLANK()))

var open_jiras = created_jiras - closed_jiras

return if(open_jiras<0,0,open_jiras)

But when I create the visual with a filter to show only the last 12 months, the measure "Remaining open" considers only the tickets created and closed during those 12 months, although I'm using the filter "allselected". This measure should consider all the tickets created and closed without applying any date filter.

Thank you very much in advance for your help

[Corey_M]

you will likely want to use the filter keyword which would look something like this

Remaining Open =
VAR created_jiras = 
    CALCULATE(
        COUNT(Jira[Jira]),
        FILTER(
            ALL('Calendar'), 
            Jira[Creation date] <= MAX('Calendar'[Date])
        )
    )
VAR closed_jiras = 
    CALCULATE(
        COUNT(Jira[Jira]),
        FILTER(
            ALL('Calendar'),
            Jira[Closed date] <= MAX('Calendar'[Date]) && 
            Jira[Closed date] <> BLANK()
        )
    )
VAR open_jiras = created_jiras - closed_jiras
RETURN 
    IF(open_jiras < 0, 0, open_jiras)

it is possible that you have other filters that you might want to preserve which could require a slight editing of the code.