topic [JIRA]: How to get count of bugs that got reopened in DAX Commands and Tips

[JIRA]: How to get count of bugs that got reopened

SergioHB — Tue, 11 Jun 2024 11:47:06 GMT

Hi all,

I'm working on a Service Desk dashboard and trying to generate quality KPI for my team. At the moment, I need to know How many bugs got re-opened (transition from Closed to InProgress).

Basically, I just want to store in a custom field the number of times certain transition is executed. (not just to measure total number of cases reopened but also number of times one case has been reopened) so I'd say, that field has to increase by 1 everytime a ticket is transitioned.

I'm pulling data from Jira Service Desk (Service Project) and that is coming on a similar presentation:

Whats the best way to acheive this?

Thank you in advance for your help.

Sergio

Re: [JIRA]: How to get count of bugs that got reopened

Anonymous — Wed, 12 Jun 2024 02:04:53 GMT

Hi SergioHB ,

You can add a measure like below:

REOPENED = CALCULATE ( COUNTROWS ( FILTER ( 'Table', 'Table'[Request] = SELECTEDVALUE ( 'Table'[Request] ) ) ), 'Table'[Status] = "Closed" ) - 1

Final output:

How to Get Your Question Answered Quickly - Microsoft Fabric Community

If it does not help, please provide more details with your desired out put and pbix file without privacy information.

Best Regards,

Ada Wang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Re: [JIRA]: How to get count of bugs that got reopened

SergioHB — Wed, 12 Jun 2024 11:10:46 GMT

Hi Anonymous

Thanks for this, I'd say it works for counting on a request. But what if want to measure also the Total Number of Reopened cases? Using the same data I provided, we agreed on how many times each request was reopened but then need to measure by cases.

Does this makes sense to you?

Thnks

Re: [JIRA]: How to get count of bugs that got reopened

Anonymous — Thu, 20 Jun 2024 05:45:59 GMT

Hi SergioHB ,

Add measures like below:

case_closed_once = VAR _number = IF ( [REOPENED] > 0, 1, 0 ) VAR _closed = CALCULATE ( DISTINCTCOUNT ( 'Table'[Request] ), FILTER ( 'Table', _number = 0 ) ) RETURN _closed

count_no_reopended = SUMX ( VALUES ( 'Table'[Request] ), [case_closed_once] )

Total Cases Reopended = VAR _all = DISTINCTCOUNT('Table'[Request]) RETURN _all-[count_no_reopended]

Final output:

How to Get Your Question Answered Quickly - Microsoft Fabric Community

If it does not help, please provide more details with your desired out put and pbix file without privacy information.

Best Regards,

Ada Wang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.