Forum Discussion

srahzafar9's avatar
srahzafar9
Regular Visitor
5 years ago

Open, close and backlog tickets

 

I have these 2 tables that are connected through timeID, I need to create a dax for Open,  Close and Backlog incidents on monthly basis for example in the month of may count the number of incidents that are open and have open date started in May, No of tickets closed in May and No of backlog tickets that were opened before May and are still open in May. I have a month slicer and my chart should show open, close and backlog tickets versus months on x axis. 

Close and Backlog Tickets
Open

1 Reply

  • selimovd's avatar
    selimovd
    Icon for Most Valuable Professional rankMost Valuable Professional
    5 years ago

    Hey srahzafar9 ,

     

    you can get the amount of open or closed with the following measure:

    Open Incidents =
CALCULATE(
    COUNTROWS( Table2 ),
    Table2[Status] = "Open" && Table2[Type] = "Incident"
)

     

    As your data is connected by TimeID you just have to put the desired time frame in a visual, for example May, and you can analyze what you want.

     

    If you need any help please let me know.
    If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍
     
    Best regards
    Denis