Create a New Measure to get the Committed Story Points with in a Sprint

Questions & Answers
1

I have created a below measure to get the committed story points count of issues that are not in cancelled status. Unfortunately, this measure shows the cancelled status tickets also. help me to get the story points count while excluding cancelled status tickets

(
[Measures].[Story Points history],
[Time].CurrentHierarchy.Levels(‘Day’).DateMember(
DateAddDays(
[Sprint].CurrentMember.get(‘Start date’),1
)
),[Issue Type].[All Issue Types]
)-([Status.By name].[Cancelled])

Thanks & Regards
Raju

2

Hi @VNRajuVallabhaneni

If you have individual Issues in the Rows section of the report, you can select the “Issue Status” property from the Measures dimension, click the column header of this property and select “Filter rows” → “not matches Cancelled”.

This will hide any issues currently in the Cancelled status.

​Best regards,
​Nauris