Forum Discussion
Helper IIPercentage of features completed
v-venuppu The solution is as follows
a) Create 2 Copies of the complete dataset as tables which has the list of all features and stores linked using ParentWorkItem ID
b) Rename the tables of dataset as Features and Stories
c) Create one to many relation from Features table by mapping Work Item ID field to Parent Work Item ID in Stories table
d) Create 2 measure - Completed Story Points and Total Story Points in the Features table
e) Completed Story Points - Use SumX to sum all stories that are in completed or done status
f) Total Story Points - Use SumX to sum the story points from all stories
f) Create a measure called % Completion using Completed and Total Story Points
Community SupportHi SureshAnanth ,
Great to hear that it's working.Could you please share the solution? It would be really helpful for others in the community who might be facing similar issues and can address them quickly. Also, I would suggest accepting your approach as the solution so that it can benefit others as well.
Thank you.
v-venuppu The solution is as follows
a) Create 2 Copies of the complete dataset as tables which has the list of all features and stores linked using ParentWorkItem ID
b) Rename the tables of dataset as Features and Stories
c) Create one to many relation from Features table by mapping Work Item ID field to Parent Work Item ID in Stories table
d) Create 2 measure - Completed Story Points and Total Story Points in the Features table
e) Completed Story Points - Use SumX to sum all stories that are in completed or done status
f) Total Story Points - Use SumX to sum the story points from all stories
f) Create a measure called % Completion using Completed and Total Story Points