Need an eazybi calculated measure to filter out multiple FixVersions

Questions & Answers
1

Hello,

We’re trying to create a calculated measure to return issues where the Fix and Affect Versions are equal, however we use the Fix Version to indicate the release when the story was released to end users, so we need a way to filter out any Fix Versions with more than 1 entry in the field.

This is the measure we started with

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

2

Hi @l_deyarmin,

Welcome to the eazyBI Community!
Thanks for posting your question!
I recommend defining a new calculated measure with the formula below and see if that works for you? Depending on how you want to display the report, you might need to apply additional row filter on this measure for results to be > 0

Sum(
  Filter(
    Descendants([Issue].CurrentHierarchy,[Issue].[Issue]),  
 CoalesceEmpty([Measures].[Issue fix versions],"") MATCHES
      Replace(
        CoalesceEmpty([Measures].[Issue affects versions],"")
        ,',','|')
  ),
[Measures].[Issues created]
)

Best wishes,

Elita from support@eazybi.com

3

Thank you for your response, upon re-reading my post, I realize it was poorly worded. What I am trying to find is any issue where the FixVersion and AffectsVersion are exactly equal to one another and exclude any issues were the FixVersion contains multiple values.