Estimated Yes / No Chart - Story Points plus another field

Dear all,

I use a simple graph to show the Number of Estimated vs Unestimated Items.
Considering just the field Story Points that works fine:


I am using these measures:

  • With Story Points is easy, just “[Measures].[Issues with Story Points created]”
  • Without Story Points is:
    CASE WHEN [Measures].[Issues Created] > 0 AND
    NOT [Measures].[Issues created] =
    [Measures].[Issues with Story Points]
    [Measures].[Issues created] -
    [Measures].[Issues with Story Points]

Now I want to consider a second field (Custom Field called “Effort Size”). So I try to create two new calculated measures:

  1. Estimated = Non Empty Story Points OR Non Empty Effort Size
  2. Not Estimated = Empty Story Points AND Empty Effort Size

What would the best way to implement them?
I was triyng some Count and Filter Functions, but I could not get it to work : /

Big thank you in advance.


Hi Markus,

As in this case, you would like to apply two conditions to each issue, it would be necessary to build a calculated measure using some aggregate function and filter all issues which have one or another condition. For example:

  Descendants([Issue].CurrentMember, [Issue].[Issue]),
  [Issue].CurrentHierarchyMember.get("Effort Size") MATCHES '\(none\)'
AND isEmpty([Issue].CurrentHierarchyMember.get("Story Points")) 
AND [Measures].[Issues Created] > 0 )))

Lauma /

Thank you very much, that works perfectly :+1:t4::grinning:

1 Like