Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
Anonymous
Not applicable

Count monthly inprogress ticket

Hello,

 

I would like to count the monthly/weekly unresolved tickets , here is the data sample : 

 

Category createdresolutiondate
AA11/10/2019 13:44:56null
AA03/10/2019 16:55:17null
AA06/09/2019 10:17:2611/10/2019 14:17:08
BB08/10/2019 15:20:03null
CC08/10/2019 14:46:50null
AA08/10/2019 14:40:11null
BB08/10/2019 08:34:12null
CC07/10/2019 09:46:58null
DD04/10/2019 11:58:14null
AA03/10/2019 13:08:51null
CC01/10/2019 11:31:4701/10/2019 18:56:07
DD25/09/2019 17:39:51null
BB30/09/2019 15:26:1107/10/2019 17:57:11
BB27/09/2019 09:50:46null
CC25/09/2019 16:36:14null
AA24/09/2019 16:37:1810/10/2019 15:42:18

 

The inprogress ticket is the one doesn't have the resolution date at the end of the month or the week or at the given date.

Please advise.

Thanks in advance. 

 

1 ACCEPTED SOLUTION

Hi @Anonymous ,

 

Please use ALL instead of ALLSELECTED to have a try.If it doesn't meet your requirement, kindly share your sample data and excepted result to me if you don't have any Confidential Information. Please upload your files to One Drive and share the link here.

 

Unresolved =CALCULATE (COUNTA(Bug[created]);
FILTER( ALL(Bug);
(Bug[resolutiondate] = BLANK() || Bug[resolutiondate]> Maxx (Calendrier;Calendrier[DateSlicer] )) 
&& Bug[createddate]<=Maxx ( Calendrier; Calendrier[DateSlicer] )
)
)
Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the others find it more quickly.

View solution in original post

8 REPLIES 8
Ashish_Mathur
Super User
Super User

Hi,

You may download my PBI file from here.

Hope this helps.

Untitled.png


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/
PattemManohar
Community Champion
Community Champion

@Anonymous  Please try this as a "New Table" 

 

Test05Out = FILTER(SUMMARIZECOLUMNS(Test05[resolutiondate],"Count",COUNT(Test05[Category ])),Test05[resolutiondate]<>BLANK())

image.png

Use the resolutiondate as your date hierarchy column to view the counts by Month or Week





Did I answer your question? Mark my post as a solution!

Proud to be a PBI Community Champion




Anonymous
Not applicable

Hi 

 

Unresolved =CALCULATE (COUNTA(Bug[created]);
FILTER( ALLSELECTED(Bug);
(Bug[resolutiondate] = BLANK() || Bug[resolutiondate]> Maxx (Calendrier;Calendrier[DateSlicer] ))
&& Bug[createddate]<=Maxx ( Calendrier; Calendrier[DateSlicer] )
)
)
Do you have any idea ? Thanks in advance. 
 

 

Hi @Anonymous ,

 

Please use ALL instead of ALLSELECTED to have a try.If it doesn't meet your requirement, kindly share your sample data and excepted result to me if you don't have any Confidential Information. Please upload your files to One Drive and share the link here.

 

Unresolved =CALCULATE (COUNTA(Bug[created]);
FILTER( ALL(Bug);
(Bug[resolutiondate] = BLANK() || Bug[resolutiondate]> Maxx (Calendrier;Calendrier[DateSlicer] )) 
&& Bug[createddate]<=Maxx ( Calendrier; Calendrier[DateSlicer] )
)
)
Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the others find it more quickly.

@Anonymous Please create these two measures.

 

Open Tickets = COUNTROWS(FILTER(Test05,Test05[resolutiondate]=BLANK()))

Closed Tickets = COUNTROWS(FILTER(Test05,Test05[resolutiondate]<>BLANK()))

image.png





Did I answer your question? Mark my post as a solution!

Proud to be a PBI Community Champion




Anonymous
Not applicable

hi @PattemManohar 

I need to create a measure, not a table. Thanks for your advise. 

@Anonymous Those two I've mentioned are measures, and the same are used in the Chart.




Did I answer your question? Mark my post as a solution!

Proud to be a PBI Community Champion




Anonymous
Not applicable

Hi,

 

If I understand well, these closed and Open tickets are measure in the table 

Test05Out

I already have 2 measures Open / Closed tickets, I would like to create another measure of the non resolved ticket. Let me know if It's clear for you or maybe I don't understand well 🙂

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.