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