cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Frequent Visitor

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

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

3 REPLIES 3
Super User

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.

Regards,
Ashish Mathur
http://www.ashishmathur.com
Super User

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

Become an expert!: Enterprise DNA
External Tools: MSHGQM
Latest book!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...
Frequent Visitor

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

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

#### Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

#### Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors
Top Kudoed Authors