Forum Discussion

BEENSGROEPADMIN's avatar
BEENSGROEPADMIN
Frequent Visitor
3 years ago

Cummulative sum by one value till maximum

Hello,   The following table is relevant to know for this case. 1. Production quantities: this table lists a quantity of the total project per production activity: The first row contains pr...
Need Help
Syndicate_Admin's avatar
Syndicate_Admin
Administrator
3 years ago

Hi, @Syndicate_Admin

I'm curious to know how your week chart relates to the data sheet. You can try the following methods.

Measure1 = 
Var _aver1=CALCULATE(MAX('Table'[Doorlooptijdbegroting]),FILTER(ALL('Table'),[Activiteit]="Aanbrengen damwanden (drukken)"))
Var _max1=CALCULATE(MAX('Table'[Hoeveelheden]),FILTER(ALL('Table'),[Activiteit]="Aanbrengen damwanden (drukken)"))
Var _runningsum=SUMX(FILTER(ALL(Week),Week[Week]<=SELECTEDVALUE(Week[Week])),_aver1)
Return
IF(_runningsum<=_max1,_runningsum,"descanso")
Measure2 = 
Var _aver1=CALCULATE(MAX('Table'[Doorlooptijdbegroting]),FILTER(ALL('Table'),[Activiteit]="Aanbrengen damwanden (trillen)"))
Var _max1=CALCULATE(MAX('Table'[Hoeveelheden]),FILTER(ALL('Table'),[Activiteit]="Aanbrengen damwanden (trillen)"))
Var _runningsum=SUMX(FILTER(ALL(Week),Week[Week]<=SELECTEDVALUE(Week[Week])),_aver1)
Return
IF(_runningsum<=_max1,_runningsum,"descanso")

If the result is different from what you expected, please tell more details.

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.