Cumulatives in Progress (count) and Cumulative in Progress Planned

[IAM]

I've been working on this for 8 hours, had help, and still it isn't right. Please help me! I have tried multiple, but every one is not correctly working after all.

I need a graph where I can see the weeks on the X-axes.

(The weeks are in the DateDimension table, the DateKey is in relation with ProgressTool[Cable Pulling ACTUAL])

I want to see the cumulative progress per week. (if it helps: in column ProgressTool[Cable Pulling ACTUAL Exist] I have a one if a date is given, so that means it is executed.

Next I have a table with planned totals per week.

Here I want the cumulatives as well. Per week I want to see the amount of workorders added to the amount of the previous week.

PlanningTable[Datum] is in relation with DateDimension[DateKey]

Together I want to make something like this:

Please help me out!

[v-yalanwu-msft · Accepted solution]

Hi, @IAM ;

I create a simple example, and if you want to calculate cumulatives ,you could try :

Measure = CALCULATE(SUM([value]),FILTER(ALL(Table1),[Week]<=MAX('Table1'[Week])))

The final show:

Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.