Total value is greater than row count

Questions & Answers
1

Hi there,

While I’m working on my eazyBI report, I found something strange.
I created several calculated measures to track issues with custom field values. One of the measures is defined as following.
startdate and onlinedate are two custom fields created in Jira.
count(
Filter(
Descendants([Issue].CurrentMember,[Issue].[Issue]),
NOT IsEmpty([Measures].[Issue startdate]) AND
NOT IsEmpty([Measures].[Issue onlinedate]) AND

(DateInPeriod(
  [Measures].[Issue startdate],
  [Time].CurrentHierarchyMember
)
AND
DateInPeriod(
  [Measures].[Issue onlinedate],
  [Time].CurrentHierarchyMember
)
)

),ExcludeEmpty
)

However, I found that the total value and row count are different when I drill through issues.

image
image1154×238 13.5 KB

I tried to roll out unwanted issues in filter with some criteria but it seems that they’re not working as expected. Can you help me out here? Thanks a lot!

2

Hi @matthew,
welcome to eazyBI community :wave:

In your formula, you don’t need to use ExcludeEmpty as you are already using Filter() function that is filtering issues that you want to count. ExcludeEmpty is using default measure Issues Created and because of that can give you misleading results.
A better way for this formula would be this (I added also measure Issues with startdate as currently, you have only filtering by properties in your formula):

NonZero(
  count(
    Filter(
        Descendants([Issue].CurrentMember,[Issue].[Issue]),
        NOT IsEmpty([Measures].[Issue startdate]) AND
        NOT IsEmpty([Measures].[Issue onlinedate]) AND
        [Measures].[Issues with startdate] > 0 AND
        DateInPeriod(
          [Measures].[Issue startdate],
          [Time].CurrentHierarchyMember)
        AND
        DateInPeriod(
          [Measures].[IIssue onlinedate],
          [Time].CurrentHierarchyMember)
    )
  )
)

Please check if this returns your correct count when you drill through. If not, please send your report definition with PrintScreens of your report to support@eazyBI.com. There can be several reasons for this difference to happen and the report context can influence it in different ways.

best,
Gerda // support@eazyBI.com