sum calculatin using filter and all functions

Question

Hi,Having table below I need calculate total sum after certain time id (10/15/2023 in example) and present it in each cell as following.using filter(Time ID &gt; 10/15/2023) and then all(Time ID) doesnt work&nbsp;Please help&nbsp;Time IDCOMPLETED_PER_WEEKCompleted Effort Sum using filterNeed to present7/30/20233.43&nbsp;&nbsp;8/6/20239.63&nbsp;&nbsp;8/13/20231.15&nbsp;&nbsp;8/20/20232.23&nbsp;&nbsp;8/27/20230.5&nbsp;&nbsp;9/3/20235.48&nbsp;&nbsp;9/10/20230.63&nbsp;&nbsp;9/17/20230&nbsp;&nbsp;9/24/20232.28&nbsp;&nbsp;10/1/20232.42&nbsp;&nbsp;10/8/20233.29&nbsp;&nbsp;10/15/20231.361.3624.2410/22/20238.2458.24524.2410/29/20237.697.6924.2411/5/20235.795.7924.2411/12/20230.9550.95524.2411/14/20230.20.224.24Total55.2824.24&nbsp;

amitchandak · Accepted Answer

polinab , Based on what I got 
Assume Completed&nbsp; is column we need sum
&nbsp;
Calculate(Sum(Table[Completed]) , filter(allselected(Table), Table[Time] &gt; Date(2023,11,15) ) )

Forum Discussion

sum calculatin using filter and all functions

2 Replies

Related content

Caclulate function over riding filter?

filter function

Filter function is not filtering

DATESYTD function

Date filter in Calculate function

Time ID	COMPLETED_PER_WEEK	Completed Effort Sum using filter	Need to present
7/30/2023	3.43
8/6/2023	9.63
8/13/2023	1.15
8/20/2023	2.23
8/27/2023	0.5
9/3/2023	5.48
9/10/2023	0.63
9/17/2023	0
9/24/2023	2.28
10/1/2023	2.42
10/8/2023	3.29
10/15/2023	1.36	1.36	24.24
10/22/2023	8.245	8.245	24.24
10/29/2023	7.69	7.69	24.24
11/5/2023	5.79	5.79	24.24
11/12/2023	0.955	0.955	24.24
11/14/2023	0.2	0.2	24.24
Total	55.28	24.24