In Progress Story points in a Sprint by Issue Status

Hi,

I am wondering what is the best way to calculate Sum of story points in progress in an active Sprint by issue status. Here is what I am using right now and I believe this can be optimized.

([Measures].[Sprint Story Points Commitment], [Status].[Dev in Progress] ) +
([Measures].[Sprint Story Points Commitment], [Status].[In Review] ) +
([Measures].[Sprint Story Points Commitment], [Status].[In Progress] ) +
([Measures].[Sprint Story Points Commitment], [Status].[HOLD] ) +
([Measures].[Sprint Story Points Commitment], [Status].[Peer Review] ) +
([Measures].[Sprint Story Points Commitment], [Status].[Ready for QA] ) +
([Measures].[Sprint Story Points Commitment], [Status].[Deployment in Progress] ) +
([Measures].[Sprint Story Points Commitment], [Status].[QA in Progress] ) +
([Measures].[Sprint Story Points Commitment], [Status].[Ready for Acceptance] )

Note - Sprint Story Points Commitment is a custom measure

Thanks

@vin2021

If you want to filter the report results by current status, you could try this optimized formula:

Sum(
  {[Status].[Dev in Progress],
  [Status].[In Review], 
  [Status].[In Progress],
  [Status].[HOLD],
  [Status].[Peer Review],
  [Status].[Ready for QA],
  [Status].[Deployment in Progress],
  [Status].[QA in Progress],
  [Status].[Ready for Acceptance]
},
[Measures].[Sprint Story Points Commitment]
)

If you want to calculate the historical value of committed sprint story points you would need to use “Transition Status” dimension instead

Martins / eazyBI support

Very helpful. Thank you.