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
Hi SureshA ,
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data. We can better understand the problem and help you
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly