Need help in creating a Dashboard with Fix version = ABC and Fix version != DEF

Questions & Answers
1

A. Issues are tagged with 2 Fix versions

  1. Few Issues with “ABC” as only Fix version
  2. Few Issues with fix both version as “ABC” and “DEF”
    B. I want to create a Dashboard with Fix version = ABC and Fix version != DEF.

Need help

2

Hi,

I think you could create a calculated measure using Aggregate(except) to have a member that excludes all issues with fix Version = DEF.
Then Create a second measure that would be the tuple of ABC and Your Aggregate(except)
Tuples can only contain members of different dimensions, so everything would need to be done in Measures.
It would look something like that.

1st calculated member:  [Measure].[NO_DEF]
Aggregate( Except([Fix version].[Fix Version].Members, 
 { [Fix version].[DEF] }  --List members to exclude
 ))

2nd Calculated Member : [Measure].[ABC_NoDEF]
([Fix Version].[ABC],
[Measure].[DEF]
)

There might be better/easier solutions, but that’s the only one I can think of at the moment.

Have a good day,
Marilou

3

Hi,

Such filtering of the issues having only one specific version is impossible with the aggregated members in the multiple value dimension.

The logic of such filtering must be implemented in the formula of the custom measure.
The following example counts the issues with a specific Fix version as the only Fix version:

NonZero(Count(
  Filter(Descendants([Issue].CurrentMember,[Issue].[Issue]),
  [Measures].[Issue fix versions]=[Fix Version].CurrentHierarchyMember.Name
  AND
  [Measures].[Issues created]>0)
))

The idea of this formula is that it checks if the issue fix versions property is identical to the name selected in the report pages:

image
image1378×1418 149 KB

Kindly,
Janis, eazyBI support

1 Like