Forum Discussion
SureshA
Helper II
Helper IIPercentage of features completed
I have created powerbi dashboard using azure devops analytics as data source I have the list of fields from ado into powerbi WorkItem ID WorkItem Type State Parent Work ItemId The items...
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
Liu Yang, Thanks
Pls find below sample data and output
Input Data Source
| Area Path | Work Item Id | Title | State | Work Item Type | Story Points |
| Project\Product1\Squad 1 | 100 | Feature A | In Progress | Feature | 40 |
| Project\Product1\Squad 1 | 101 | Story A1 | Done | Story | 10 |
| Project\Product1\Squad 1 | 102 | Story A2 | In Progress | Story | 10 |
| Project\Product1\Squad 1 | 103 | Generic Task A3 | Done | Generic Task | 10 |
| Project\Product1\Squad 1 | 104 | Generic Task A4 | In Progress | Generic Task | 10 |
| Project\Product2\Squad 2 | 200 | Feature B | Done | Feature | 80 |
| Project\Product2\Squad 2 | 201 | Story A1 | Done | Story | 20 |
| Project\Product2\Squad 2 | 202 | Story A2 | Done | Story | 20 |
| Project\Product2\Squad 2 | 203 | Generic Task A3 | Done | Generic Task | 20 |
| Project\Product2\Squad 2 | 204 | Generic Task A4 | Done | Generic Task | 20 |
| Output Data Table |
| Area Path | Title | State | % Complete |
| Project\Product1\Squad 1 | Feature A | In Progress | 50% |
| Project\Product2\Squad 2 | Feature B | Done | 100% |