AffectsVersion ≠ FixVersion

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.


Could someone help on this?

Thank you!

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:

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

Gerda //

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?