Generating a comma-separated list of Issues for a Component

Questions & Answers
,
1

I have a report with Components as rows and I want to generate list of Epics for each component, in a single cell.
This tuple returns correct number of expected issues:
([Component],[Issue],[Issue Type].[Epic])
So I assumed that this should work for me (but it doesn’t :disappointed:):
Generate(([Component],[Issue],[Issue Type].[Epic]),[Issue].CurrentMember.GetString('Summary'),',')

2

Hey @alsodifh

Try this code for your calculated measure:

Generate(
    Filter(
    DescendantsSet([Issue.Epic].CurrentHierarchyMember,[Issue.Epic].[Epic]),
    [Measures].[Issue type] = "Epic"
    AND
    [Measures].[Issues created]>0
    ),
  Cast([Issue.Epic].CurrentMember.Key as string),
  ","
)

And make sure you imported “Epic Link” field from the import options page.

Martins / eazyBI

1 Like