# Counting sum of total open issues with a certain severity

**URL:** <https://community.eazybi.com/t/counting-sum-of-total-open-issues-with-a-certain-severity/20139>\
**Category:** Questions & Answers\
**Tags:** mdx\
**Created:** [June 16, 2025, 8:54am UTC](https://community.eazybi.com/t/counting-sum-of-total-open-issues-with-a-certain-severity/20139 "2025-06-16T08:54:33Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![KimSe](https://community.eazybi.com/letter_avatar_proxy/v4/letter/k/50afbb/32.png) [@KimSe](https://community.eazybi.com/u/KimSe)\
**Post date:** [June 16, 2025, 8:54am UTC](https://community.eazybi.com/t/counting-sum-of-total-open-issues-with-a-certain-severity/20139/1 "2025-06-16T08:54:33Z")

</div>

Hi

I need to count the sum of total open issues with a certain severity. I have made the following MDX but I currently only get “0” as a result. I am not sure if I am counting correctly or the my setup is unavailible to show what I suspect.

Can anybody advise me in direction?

MDX

 ![image](https://community.eazybi.com/uploads/default/original/2X/6/649aa0f3e38878841c994572f5e5aa3f0ae7ac9e.png)

My dimension setup

 ![image](https://community.eazybi.com/uploads/default/original/2X/f/f7d3f6e48955b34c56b0dc60fb830a73ebd8b9a2.png)

---

<div class="post-metadata">

**Author:** ![nauris.malitis](https://community.eazybi.com/user_avatar/community.eazybi.com/nauris.malitis/32/6355_2.png) [@nauris.malitis](https://community.eazybi.com/u/nauris.malitis)\
**Post date:** [June 18, 2025, 4:07pm UTC](https://community.eazybi.com/t/counting-sum-of-total-open-issues-with-a-certain-severity/20139/2 "2025-06-18T16:07:45Z")

</div>

Hi @KimSe,

This depends on how have you imported the “Severity Occurrence (Number)”.

Is this a custom field imported into eazyBI as a Dimension or as a Measure?

If this is imported as a dimension, then you can create a measure in the Measures dimension with a formula like this:

```mdx
Sum(
  Filter(
    [Severity Occurrence (Number)].[Severity Occurrence (Number)].Members,
    IIF(
      [Severity Occurrence (Number)].Currentmember.Name = "(none)",
      0,
      Cast([Severity Occurrence (Number)].CurrentMember.Name as INTEGER)
    ) > 1
  ),
  [Measures].[Open issues]
)

```

Let me know if this formula works or if it doesn’t, then how exactly are you importing the “Severity Occurrence (Number)” into eazyBI.

​Best regards,  
​Nauris

---

<div class="post-metadata">

**Author:** ![KimSe](https://community.eazybi.com/letter_avatar_proxy/v4/letter/k/50afbb/32.png) [@KimSe](https://community.eazybi.com/u/KimSe)\
**Post date:** [June 18, 2025, 5:37pm UTC](https://community.eazybi.com/t/counting-sum-of-total-open-issues-with-a-certain-severity/20139/3 "2025-06-18T17:37:38Z")

</div>

Hi Nauris

Thank you very much for the reply. Currently the “Severity Occurrence (Number)” are imported as a meassure, I cannot import as a dimension.

Can you adjust the filter to work on a “meassure” instead?

Best regards

Kim

---

<div class="post-metadata">

**Author:** ![nauris.malitis](https://community.eazybi.com/user_avatar/community.eazybi.com/nauris.malitis/32/6355_2.png) [@nauris.malitis](https://community.eazybi.com/u/nauris.malitis)\
**Post date:** [June 18, 2025, 7:20pm UTC](https://community.eazybi.com/t/counting-sum-of-total-open-issues-with-a-certain-severity/20139/4 "2025-06-18T19:20:44Z")

</div>

Sure thing!

If it is imported as both a measure and a property, you can use a formula like this:

```auto
Sum(
  Filter(
    Descendants([Issue].CurrentMember, [Issue].[Issue]),
    Cast([Measures].[Issue Severity Occurrence (Number)] AS INTEGER) > 1
  ),
  [Measures].[Open issues]
)

```

​Best regards,  
​Nauris