Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
Community Members
Community Events
Community Groups

EazyBI - Aggregate a Measure based on a filter of Issue Type and Status


I am using eazyBI and I want to aggregate a measure based on a filtered set of data based on Issue Type and Issue Status however I cannot get it to work. My Define Calculated member is as follows


[Measures].[Issue type]="ACR"
AND [Status].CurrentMember.[Approved]),
[Measures].[Issue Requested Budget (USD m)])


The problem I have is around [Status].CurrentMember.[Approved] not behaving as I am expecting I think


Thanks in advance


1 answer

0 votes

Hi @Graeme Kelly 

In this case, you could check if the field "Requested Budget (USD m)" is imported as a measure in eazyBI.

Then you could use this imported measure as a numerical value in a tuple code when creating a new calculated measure.


[Measures].[Requested Budget (USD m) created],
[Issue type].[ACR]


That would aggregate all the Requsted budget values for all issues in ACR type and Status Approved for your report.


You might also want to check different similar use-cases here:


Martins / eazyBI team

Suggest an answer

Log in or Sign up to answer

Atlassian Community Events