Create a bar chart that shows total number of active tickets (Month to Month)

[swallia23]

The Goal:  I need to be able to show a bar chart of what the total number of active tickets (month-to-month).

• I figured out how to show the total number of 'opened' and 'closed' tickets for each month.
• I figured out how to show the total number of 'open' tickets for the current month.
• But, I can't figure out how to show what the total number of open tickets at the end of each month on a month-to-month bar chart.

In my DATES table, I have created a BOM (Beginning of month) and a EOM (End of month) measure (with some help).  The theory is that if I can calculate the difference with the number of opened tickets at the beginning and end of each month, this should give me the number I'm looking for.  But, I'm not experienced enough to figure this out.  Someone did give me the below query as a starting point, but I can't get it to work since I'm not understanding the syntax. 

EOM_open = COUNTROWS(FILTER(all(new_Tickets),MAX(Dates[EOM])>MAX(new_Tickets[Date Submitted]) && MAX(Dates[EOM])<MAX(new_Tickets[Date Closed])))

As you can see below, the total current number of 'open' (not opened) tickets is 301.  I have the total number of 'opened' and 'closed' tickets monthly. 

Any help would be more than appreciated.

Thanks again, Joe

[Ashish_Mathur]

Hi,

Share data in a format that can be pasted in an MS Excel file.  Show the expected result in a Table format very clearly.

[Greg_Deckler]

@swallia23 Sounds like Open Tickets: Open Tickets - Microsoft Fabric Community

[swallia23]

@Greg_Deckler thanks, i'm checking your solution now.