Total value by date & status

Hi, I’m pretty new at EazyBI and have been struggling with this issue for a bit now.

Im trying to create a new measure for Total value by last updated date (column) and status (row).
I have created a script that works on a high level (it shows the correct total for last updated date) but it does not split for statuses.

Capture

this is my code:

Sum(Filter(
Descendants([Issue].Currentmember, [Issue].[Issue]),

    DateInPeriod(
    [Measures].[Issue updated date],
    [Time].CurrentHierarchyMember)),

[Measures].[Issue Total Value Affected GBP]

)

Would someone be able to help me on this please?
Thank you!

Hi @eva012

​Welcome to eazyBI community!
​You are already close to solution, you should only slightly adjust the Filter expression, to indicate that measure “Issues last updated” should be larger than 0. No need for the DateInPeriod function, because measure “Issues last updated” already interacts with Time dimension based on the issue last updated date.

​Please try defining a new calculated measure with the formula below and see if it works for you:

Sum(
  Filter(
    Descendants([Issue].Currentmember, [Issue].[Issue]),
    [Measures].[Issues last updated] > 0
  ),
  [Measures].[Issue Total Value Affected GBP]
)

​Best wishes,

Elita from support@eazybi.com