# Count issues with linked "analyzes" Issue type Problem Record

**URL:** <https://community.eazybi.com/t/count-issues-with-linked-analyzes-issue-type-problem-record/14735>\
**Category:** Questions & Answers\
**Created:** [January 12, 2024, 4:23pm UTC](https://community.eazybi.com/t/count-issues-with-linked-analyzes-issue-type-problem-record/14735 "2024-01-12T16:23:04Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![a.hauser](https://community.eazybi.com/letter_avatar_proxy/v4/letter/a/f14d63/32.png) [@a.hauser](https://community.eazybi.com/u/a.hauser)\
**Post date:** [January 12, 2024, 4:23pm UTC](https://community.eazybi.com/t/count-issues-with-linked-analyzes-issue-type-problem-record/14735/1 "2024-01-12T16:23:04Z")

</div>

Hi Community,

i try to count all created Spikes that are linked via issue links ‘analyzes’ to a problem record.  
I got it to have all spike which have an analyzes outlink but struggle with the issue type problem record linked.

I use this measure:  
NonZero(Sum(Filter(  
Descendants([Issue].CurrentMember, [Issue].[Issue]),  
not isEmpty([Issue].CurrentHierarchymember.Get(‘analyzes’))

AND  
DateInPeriod(  
[Measures].[Issue created date],  
[Time].CurrentHierarchyMember  
)),  
[Measures].[Issues created]  
))

Where do I have to add the Issue type filter?

---

<div class="post-metadata">

**Author:** ![a.hauser](https://community.eazybi.com/letter_avatar_proxy/v4/letter/a/f14d63/32.png) [@a.hauser](https://community.eazybi.com/u/a.hauser)\
**Post date:** [January 17, 2024, 7:34pm UTC](https://community.eazybi.com/t/count-issues-with-linked-analyzes-issue-type-problem-record/14735/2 "2024-01-17T19:34:35Z")

</div>

has anybody an idea?

---

<div class="post-metadata">

**Author:** ![gerda.grantina](https://community.eazybi.com/user_avatar/community.eazybi.com/gerda.grantina/32/1994_2.png) [@gerda.grantina](https://community.eazybi.com/u/gerda.grantina)\
**Post date:** [January 25, 2024, 3:42pm UTC](https://community.eazybi.com/t/count-issues-with-linked-analyzes-issue-type-problem-record/14735/3 "2024-01-25T15:42:30Z")

</div>

Hi @a.hauser ,  
If you have “Issue” dimension in rows and want to see all the linked analyze problem records, then you can:

1. Use the `issue_type` parameter in the “analyze” issue link configuration. See detailed instructions here in this article. That will create a dimension that holds only the ‘problem’ issue types, and thus, the reporting will be straightforward:

> [@Import issue links as dimension](https://community.eazybi.com/t/import-issue-links-as-dimension/6652):
>
> [Issue linking](https://support.atlassian.com/jira-software-cloud/docs/link-an-issue/)in Jira is a powerful option and is widely used. You can import issue links in eazyBI by using [advanced settings for custom fields](https://docs.eazybi.com/eazybi/data-import/data-from-jira/jira-custom-fields/advanced-settings-for-custom-fields). In this article, I will try to explain how to set up and [import issue links](https://docs.eazybi.com/eazybi/data-import/data-from-jira/advanced-data-import-options/import-issue-links) in eazyBI. There can be several use cases on what exactly users want to track in eazyBI with issue links. To demonstrate it, I will take one simple relation: stories with linked bugs. You can analyze this use case from two perspectives. One is to track Stori…

1. Create an MDX calculation that will filter all related ‘problem’ issue types, but keep in mind that this solution iterates through all dimension members and could cause performance issues. Please check the spelling of your dimension ‘analyzes’ and see other MDX examples in [this training account report](https://eazybi.com/accounts/22010/cubes/Issues/reports/376216-stories-with-bugs-details).

```auto
CASE WHEN
  [Issue].CurrentMember.Level.Name = "Issue"
  AND
  [analyzes].Currentmember is [analyzes].Defaultmember
THEN
  -- retrieve linked issue information from Issue property 'analyze'
  Nonzero(Count(
    Filter(
      [Issue].CurrentHierarchy.GetLinkedmembers('analyzes'),
      [Measures].[Issue type] = "Problem")
  ))
ELSE
 -- total calculation for any issue, data on linked issue level
  NonZero(Sum(
    Filter(
      DescendantsSet([analyzes].Currentmember, [analyzes].[analyzes]),
      [Issue Type].[Issue Type].getMemberNameByKey(
        [analyzes].CurrentHierarchyMember.get('Issue type ID')
      ) = "Problem"),
      -- counts how many times linked issues are reference with issues, this works as a filter as well
    [Measures].[Issues created]
 ))
END

```

Best,  
Gerda // [support@eazybi.com](mailto:support@eazybi.com)