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)
[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?
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 // firstname.lastname@example.org
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?