How to filter fix version status

Questions & Answers
1

Hi, I have this data

1
11447×614 75.5 KB

and I want to filter the fix version status only shown ‘released’ into this report

Capture
Capture1444×552 62.8 KB

Generate(Filter(
[Fix Version].[Version].Members,
–
DateInPeriod(
[Fix Version].CurrentMember.get(‘Release date’),
[Time].CurrentHierarchyMember
)
AND ([Time].CurrentHierarchy.DefaultMember,
[Measures].[Issues created]) > 0

  ),

[Fix Version].CurrentHierarchyMember.GetString(‘Description’),
', ’
)

tried this
CASE WHEN
[Fix Version].CurrentHierarchyMember.Get(‘Status’)=‘RELEASED’
THEN
Generate(Filter(
[Fix Version].[Version].Members,

         DateInPeriod(
         [Fix Version].CurrentMember.get('Release date'),
             [Time].CurrentHierarchyMember
        ) 
        AND ([Time].CurrentHierarchy.DefaultMember,
          [Measures].[Issues created]) > 0
          ), 
      [Fix Version].CurrentHierarchyMember.GetString('Description'),
          ', ')
END

but nothing appeared on the table

2

Hello,

I think this should work:

image

3

Hi @Rika_Mandasari,

Try including the condition on the Fix version status inside the Filter() function. The calculated measure could look similar to the one below:

Generate(
  Filter(
    [Fix Version].[Version].Members,
    DateInPeriod(
      [Fix Version].CurrentMember.get('Release date'),
      [Time].CurrentHierarchyMember
    )
    AND
    ([Time].CurrentHierarchy.DefaultMember,[Measures].[Issues created]) > 0
    AND
    [Fix Version].CurrentMember.get('Status') = 'Released'
  ),
  [Fix Version].CurrentHierarchyMember.GetString('Description'),
  ', '
)

Best,
Roberts // support@eazybi.com

1 Like