Ageing calculation using DAX

• In the Below DAX function we are calculating ageing only for the tickets which are open.
• If the Ticket is closed, then it is mentioned as "NA" 

DAX Code

Ageing Working Days =

var status1=SELECTEDVALUE(Main[Status])

RETURN

if(

    status1 in {"Open"},

CALCULATE(

    COUNTROWS('fct_Date Table'),

    DATESBETWEEN('fct_Date Table'[Date], max('Main'[SubmittedDate]), TODAY() - 1),

    'fct_Date Table'[IsWorkingDay] = TRUE,'Main'[Status] IN {"Open"},

    ALL('Main')),

    "NA"

)