Count issues with certain statuses (Jira)

Questions & Answers
,
1

Trying to create a calculated measure showing a count of any of three statuses in measure Product Status1. We want a count of all issues fitting any of these statuses. This formula works when it is only ONE status, but not for all three. Help?

NonZero(
Count(
Filter(
Descendants([Issue].CurrentHierarchyMember,[Issue].[Issue]),
Not IsEmpty([Measures].[Issue Project Status1])
AND
[Measures].[Issue Project Status1]=
“Complete”
OR
“Live in Production”
OR
“Set Live - Waiting for First Live File”
)
)
)

2

Hello @hjd

Careful when combining AND and OR operators… use parenthesis to make sure you’ll get what you need!

First: you don’t need “Not IsEmpty” clause, as you check for a specific value afterwards.
Second: replace
[Measures].[Issue Project Status1]= “Complete” OR ...
with (including parenthesis!)

(
[Measures].[Issue Project Status1] = “Complete” OR
[Measures].[Issue Project Status1] = “Live in Production” --OR
-- etc
)

But this is not really the best way to do it. Calculations in Measures dimension can be very ‘expensive’.
Instead, add your “Status” dimension to columns, ‘Define a new calculated member’ (see image) with the formula below and click on it to activate (it will look like “All statuses”):

Aggregate(
  {
      [Status][Complete],
      [Status][Live in Production],
      [Status][Set Live - Waiting for First Live File]
  }
)

image

Hope it helps!
Vasile S.

2 Likes
3

Thanks! The dimension fix definitely helps. Still not quite there with the calculated measure, but this will get me where I need to go right now. I appreciate the help!

1 Like
4

Hi @hjd,

You can define a new calculated measure that forms a tuple of the desired measure and the Status dimension calculated measure suggested by @VasileS :+1: . For example, the formula could look similar to the one below:

([Measures].[Issues created],
[Status].[CALCULATED MEMBER NAME])

Replace CALCULATED MEMBER NAME with the name you gave to the Status dimension calculated member.

I recommend you watch a presentation by my colleague Ilze about gradually increasing the complexity of MDX calculations - Training videos on specific topics.

Best,
Roberts // support@eazybi.com