Need help with creating measure for imported linked issue key

Questions & Answers
1

Using the following as a measure for imported linked issue key and can’t get the count:

Count(
[Issue].[Issue].GetMembersByKeys(
[Issue].CurrentMember.get(“Baseline”))
)

I can use it as a row so I know the data is there. Thought my measure might be wrong so asking here.

2

Hi,

This formula should be working fine for counting the number of linked issues.

There are a couple of things to check. As you refer to the property of the issue, this formula would work only with the Issue dimension used in the report at the Issue level. You also can check if the list of linked issues are generated as expected in a report like this, where you add the Issue Baseline property (in my example, I have the “Initiative Stories” link):

image
image.png2100×862 106 KB

Please note also to check the spelling of the “Baseline” property, it should be spelled correctly, including the letter case.

There is an example report of a training account where you can find several examples of how to count the linked issues.
https://eazybi.com/accounts/22010/cubes/Issues/reports/141158-story-and-bug-overview-by-projects

Kindly,
Janis, eazyBI support

3

Thanks for replying. Did some more investigation and found a different solution. Used the following to get the baselines

Generate(
Filter(
[Baseline].[Baseline].Members,
[Measures].[Issues created] > 0),
[Baseline].CurrentMember.Name,
', ’
)

Then used

Aggregate(
[Baseline].[Baseline].Members
)

To get the count. Having issues only identifying empty rows but can use sort for now.

4

Hi,

There is one more source to see different ways for counting related issues in eazyBI. Please, check this Demo account https://eazybi.com/accounts/22010/cubes, the report folder “6 Links and Hierarchies”

Kindly,
Janis, eazyBI support

5

I’ll take a look. Thanks for the link.