Help with cumulative Graph

[wunnavabk]

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

Release	Sprint	Title	State	Effort
Release 1	Sprint 1	Story 1	Done	5
Release 1	Sprint 1	Story 2	Done	8
Release 1	Sprint 2	Story 3	Done	5
Release 2	Sprint 1	Story 4	In Progress	3

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

[amitchandak]

@wunnavabk , Try a measure like

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

[wunnavabk]

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