# Discrepancy Between Drill‑Through Issue Count and Expected Results

**URL:** <https://community.eazybi.com/t/discrepancy-between-drill-through-issue-count-and-expected-results/20734>\
**Category:** Questions & Answers\
**Tags:** eazybi, calculatedmembers, mdx\
**Created:** [April 9, 2026, 10:56am UTC](https://community.eazybi.com/t/discrepancy-between-drill-through-issue-count-and-expected-results/20734 "2026-04-09T10:56:06Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![NextLife](https://community.eazybi.com/letter_avatar_proxy/v4/letter/n/c67d28/32.png) [@NextLife](https://community.eazybi.com/u/NextLife)\
**Post date:** [April 9, 2026, 10:56am UTC](https://community.eazybi.com/t/discrepancy-between-drill-through-issue-count-and-expected-results/20734/1 "2026-04-09T10:56:06Z")

</div>

Hello! eazyBI community everyone,

I am encountering an issue with a bar‑chart report and would appreciate any guidance you can provide.

## Bar-Chart report

**Page Filters:** Time  
**Rows:** Project, Group  
**Columns:** Measures

In the **Measures** dimension I defined the following calculated measure:

```auto
CoalesceEmpty(
  Avg(
    Filter(
      Descendants([Issue].CurrentMember, [Issue].[Issue]),
      -- Filter by time when the value for any issue
      DateInPeriod(
        -- use the Issue created date property here
        [Measures].[Issue 접수일],
        [Time].CurrentHierarchyMember
      )
      AND
      [Measures].[Issue type] = "VOC"
      AND
      [Measures].[Issue status] = "완료"
      AND
      (
        [Issue].CurrentHierarchyMember.Get("VOC Level") = "LV1"
        OR [Issue].CurrentHierarchyMember.Get("VOC Level") = "LV2"
        OR [Issue].CurrentHierarchyMember.Get("VOC Level") = "LV3"
        OR [Issue].CurrentHierarchyMember.Get("VOC Level") = "LV4"
      )
      -- [VOC Level].[L1~L4] > 0
    ),
    CASE WHEN
      [Measures].[] > 0
    THEN
      DateDiffWorkdays(
        -- use the Issue 접수일 property here
        [Measures].[Issue Start Date],
        [Measures].[Issue End Date],
        '67'
      )
    END
  ),0
)

```

When I use _Drill‑through_ on the bar ‘GroupA’, the total number of issues returned is **56** , which is far lower than the expected count. All of those issues have a value greater than 0 (i.e., ≥ 1).

* * *

## Temporary Table Report

**Page Filters:** Project, Time  
**Rows:** Issue  
**Columns:** Measures

I created a separate calculated measure to verify the count:

```auto
CASE WHEN
  DateInPeriod(
    -- use the Issue created date property here
    [Measures].[Issue 접수일],
    [Time].CurrentHierarchyMember
  )
  AND [Measures].[Issue type] = "VOC"
  AND [Measures].[Issue status] = "완료"
  AND (
        [Issue].CurrentHierarchyMember.Get("VOC Level") = "LV1"
     OR [Issue].CurrentHierarchyMember.Get("VOC Level") = "LV2"
     OR [Issue].CurrentHierarchyMember.Get("VOC Level") = "LV3"
     OR [Issue].CurrentHierarchyMember.Get("VOC Level") = "LV4"
      )
  AND [Measures].[issue 설비군] = "GroupA"
THEN
  DateDiffWorkdays(
    -- use the Issue 접수일 property here
    [Measures].[Issue Start Date],
    [Measures].[Issue End Date],
    '67'
  )
END

```

In this table I can see **130** issues (the same number I obtain from a direct JIRA query). Some rows display a value of 0, but the overall count matches JIRA.

* * *

I attempted to wrap the `DateDiffWorkdays` call with `CoalesceEmpty` and also experimented with adding a tiny offset (e.g., 0.000001) to force non‑zero results, but the count still drops dramatically (60 instead of 130).

I would like to know how to make the drill‑through on the bar‑chart report display 130 issues instead of 56.  
Thank you very much for your help.

Best regards,  
NextLife

---

<div class="post-metadata">

**Author:** ![martins.vanags](https://community.eazybi.com/user_avatar/community.eazybi.com/martins.vanags/32/8905_2.png) [@martins.vanags](https://community.eazybi.com/u/martins.vanags)\
**Post date:** [April 9, 2026, 11:25am UTC](https://community.eazybi.com/t/discrepancy-between-drill-through-issue-count-and-expected-results/20734/2 "2026-04-09T11:25:34Z")

</div>

Hi, Something seems off.

> [@NextLife](#):
>
> ```auto
> CASE WHEN
> [Measures].[] > 0
> 
> ```

What you thinkg this part does in your final calculation?  
This should be the key part to the problem you described

Try this instead (if that is date field and imported as measure and dproperty)

```auto
CASE WHEN
[Measures].[Issues with 접수일]>0

```

The following feedback might also change what you see on drill through issue screen

_“Some rows display a value of 0, but the overall count matches JIRA.”_

If the calculated value is 0, then these tickets won’t be shown in the results, as “drill through issue” feature has automatic “Nonzero” filter for results on screen.

Martins / eazyBI support