Sum issues by certain measure

Questions & Answers
2

Hi @jchouinard

In this case, you would need to create a new calculated measure using this approach

NonZero(
    Count( 
    Filter(
    Descendants([Issue].CurrentHierarchyMember,[Issue].[Issue]),
    Not IsEmpty([Measures].[Issue Service now ticket ID]) --custom field imported as property and filter
    AND
    [Measures].[Issues created]>0 --numeric measure for filter
    )
    )
    )

You should ensure that your custom field is imported as property.
If your Jira custom field’s name is Service now ticket ID there would be a new measure “Issue Service now ticket ID” created in “Measures” dimension which then is used in the code for your calculated measure (see Line5 in the code above).
If the field name is different, please adjust the code

Martins / eazyBI team

1 Like