Highest Priority during Issue life-cycle as dimension

Questions & Answers
,
1

Hi Community,
I would like to add the highest priority of an issue as a dimension.
Currently we use the priority dimension but this skews our reports as it common to reduce the priority during the issue life-cycle after a certain status. We would like to have the same functionality like the All Priorities dimension but instead of the current priority we would like it to return the highest priority.
Is this possible? Any help is appreciated.
cheers,
Alex

2

Hi @AlexD ,
You could try creating new calculated member “Highest” in “Priority” dimension using this formula.

{
[Priority].[Highest]
}

you can use the link - Calculated measures and members

Or share the snip what you are trying to do. so that we can see and help you

Regards,
Anu

3

Hi @AlexD ,
One option is to create a measure with hardcoded rank values depending on your priority name.
See the comments in the formula below:

NonZero(
  Count(
    Filter(Descendants([Issue].CurrentMember,[Issue].[Issue]),
    --filter issues and ignore the current issue priority  
    ([Measures].[Issues created],
    [Priority].DefaultMember)>0
    AND
    -- order issue priorities by the hardcoded rank
    Order(
      Filter([Priority].[Priority].Members,
      ([Measures].[Transitions to],
       [Transition Field].[Priority])>0
    ),
    --hardcoded rank
    CASE [Priority].CurrentMember.Name
    WHEN "Highest" THEN 1
    WHEN "High" THEN 2
    WHEN "Medium" THEN 3
    WHEN "Low" THEN 4
    WHEN "Lowest" THEN 5
    END,
    ASC
    --filter the report by the highest priority that matches the priority selection in pages
  ).Item(0).Name=[Priority].CurrentMember.Name
 )
)
)

In the report, this would look like this. In Pages, I am filtering the priority “Highest,” and the measure returns me issues that currently have other priorities but in history have had the “Highest” value:

Report_eazyBI_by_priorities
Report_eazyBI_by_priorities1638×856 120 KB

best,
Gerda // support@eazybi.com