AffectsVersion ≠ FixVersion

Questions & Answers
1

Hi ,

I would like to create a new measure ‘Version Compare 2’ to identify tickets where AffectsVersion ≠ FixVersion and not resolved. Here is the measure I use (I haven’t figured out how to filter not resolved tickets yet)

[Measures].[Issues created]
-
(
  [Measures].[Issues created],
  [Affects Version].[Version].GetMemberByKey([Fix Version].CurrentHierarchyMember.Key)
)

However the value look exactly the same as the issue created. The rows are project and fix versions.

image

Could someone help on this?

Thank you!

2

Hi @Lili
As the formula is referencing a particular version name from rows you need to have a “Fix version” dimension at the version level in the report:

Compare_versions
Compare_versions1520×1212 176 KB

If this is not the result you were looking for, can you share more details on how you would expect the formula to work?

best,
Gerda // support@eazybi.com

3

Hi Gerda,

Thanks for the solution! This solves the problem.

It’s fine to keep the fix version names in rows because I am looking into 1 project now, however what if I want to aggregate at project level ( not showing the fix version names in rows but project names), is there any other solution that does not require referencing a particular version name?