Forum Discussion

amit_wairkar's avatar
amit_wairkar
Frequent Visitor
1 year ago

Facing Problems with Velocity Calculation

We are trying to build Azure DevOps Metrics using the Azure DevOps server 2022 in Power BI. We referred the links given by Microsoft and tried to build some metrics but facing issues when trying to c...
Need Help
Sahir_Maharaj's avatar
Sahir_Maharaj
Super User
1 year ago

Hello amit_wairkar,

 

Can you please try this approach:

ActualStoryPoints = 
VAR CurrentSprint = SELECTEDVALUE(Sprints[SprintName])
VAR CompletedStories = 
    CALCULATETABLE(
        VALUES(WorkItems[WorkItemID]),
        WorkItems[State] = "Done",
        WorkItems[SprintName] = CurrentSprint
    )

VAR RolledOverStories = 
    CALCULATETABLE(
        VALUES(WorkItems[WorkItemID]),
        WorkItems[State] <> "Done",
        WorkItems[SprintName] = CurrentSprint
    )

VAR CompletedStoryPoints = 
    CALCULATE(
        SUM(WorkItems[StoryPoints]),
        WorkItems[WorkItemID] IN CompletedStories
    )

RETURN 
    CompletedStoryPoints