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

[Graeme Kelly]

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

Aggregate(
Filter([Issue].[Issue].Members,
[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

Graeme

[Sir Mārtiņš Vanags]

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],
[Status].[Approved],
[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:

https://community.eazybi.com/

Martins / eazyBI team