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 e...
Need Help
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