Calculate number of releases that include at least one P1 bug ticket

Questions & Answers
1

Hi, I’m trying to calculate what and how many releases contain at least one P1 priority bug on it. This is part of an effort to calculate how many releases meant to fix P1 issues vs regular releases. Thanks in advance!

2

Hi, @Jose01

Welcom to the eazyBI community.

Thank you for your question.

The one way to count the fixes that have P1 priority bugs in it is to go through Fixed Version using Descendants and see if fixes bugs have P1 priority.

The formula for calculating how many fixes has P1 priority bug might look like this:

NonZero(Count(
  Filter(Descendants([Fix Version].CurrentMember,[Fix Version].[Version]),
    ([Measures].[Issues created],
    [Issue Type].[Bug],
    [Priority].[P1] )>0
)
))

Please check if the proper Priority name (P1?) is included in the formula.

Kindly,
Ilze

3

@ilze.mezite Thank you so much for the quick response. This is what I was looking for. Thanks again! very helpful!