Forum Discussion

wunnavabk's avatar
wunnavabk
Regular Visitor
3 years ago

Help with cumulative Graph

Hi,

I am a new bee and trying to prepare a graph in Power BI.  I have connected PowerBI with Azure Devops and pulled the data.

I am trying to build a graph which will show incremental delivery of effort sprint after sprint.

My data is something like below

 

ReleaseSprintTitleStateEffort
Release 1Sprint 1Story 1Done5
Release 1Sprint 1Story 2Done8
Release 1Sprint 2Story 3Done5
Release 2Sprint 1Story 4In Progress3

I want to prepare a graph to show cumulative delivery of effort per Release and Sprint as below.

 

 

Could not figure out how to do it.

 

Thanks in

Need Help

2 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    3 years ago

    wunnavabk , Try a measure like

     

    calculate(Sum(Table[Effort]), filter(allselected(Table), Table[Sprint]<= max(Table[Sprint]) ) )

    • wunnavabk's avatar
      wunnavabk
      Regular Visitor
      3 years ago

      sorry for delayed response.

      Thank you amitchandak for your solution, but however i could not see the results what i am expecting, instead it is showing different result.

      My requirement is to produce a Burnup chart with cumulative scope & cumulative completed.

      My actual result should look like something below.

      Total Completed= cumulative sum by each sprint

      Product backlog= cumulative sum of scope

      but instead I am getting cumulative of the efforts in the sprint. which is also nice to represent, but completed is what i am not able to show case.

       

      below are the mesures which i have used.

      Cumulative Scope = CALCULATE (SUM(AllData[Effort]),FILTER (ALLSELECTED(AllData), AllData[Created Date] <= MAX (AllData[Created Date])))
       
      Cumulative (Completed) =
      var cumu= CALCULATE(SUM(AllData[Effort]),FILTER(ALLSELECTED(AllData),AllData[Iteration End Date]<=Max(AllData[Iteration End Date]))) return
      CALCULATE(cumu, FILTER(ALLSELECTED(AllData), AllData[State] IN { "Done","Resolved","Closed" }) )

       

       

      Thanks in advance