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 Requested Budget (USD m)])
The problem I have is around [Status].CurrentMember.[Approved] not behaving as I am expecting I think
Thanks in advance
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],
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