Open, close and backlog tickets

[srahzafar9]

 

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. 

[selimovd]

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

Blog: WhatTheFact.bi

Follow me: twitter.com/DenSelimovic