Roll up number field using two conditions

Questions & Answers
1

I am trying to create a rolled up view of a number field for Initiatives > Epics using this calculated measure.

Cache(
sum(
    Filter(Descendants([Issue].CurrentMember,[Issue].[Issue]),
    [Measures].[Issues created]>0),
  
    sum(
      Filter(Descendants([Issue].CurrentMember,[Issue].[Issue]),
      [Measures].[Issue type]="Epic"),
      [Measures].[Number Field])  
  )
  
  )

Basically I want to filter twice, first using number of issues created > 0 and the next one using the issue type=“Epic”.

It works well but it is too slow. Is there any other way to do it?

Thanks

2

Hi @ravisagar,

eazyBI automatically creates aggregated members for the numeric custom fields, totals of custom number fields.
So, instead of calculation, I would suggest using the Number Field created measure.

Lauma / support@eazybi.com