How to Calculate a sum of days for a CaseID

[BenJB]

I have a table that contains a 'CaseID', 'Status' and a 'Runningtime_Days'

Per 'CaseID' i can have multiple rows one for each 'Status'.

Wanted result 'TOTAL_Runningtime_Days'

For example

CaseID	Status	Runningtime_Days
1	1	1
1	2	15
2	1	2
3	1	1
3	2	18
3	3	5

Expected result:

CaseID	Status	Runningtime_Days	TOTAL_Runningtime_Days
1	1	1	16
1	2	15	16
2	1	2	2
3	1	1	24
3	2	18	24
3	3	5	24

[Kedar_Pande · Accepted solution]

Create a Calculated Column

TOTAL_Runningtime_Days = 
CALCULATE(
SUM(YourTableName[Runningtime_Days]),
ALLEXCEPT(YourTableName, YourTableName[CaseID])
)

If this helped, a Kudos 👍 or Solution mark would be great!
Cheers,
Kedar Pande
www.linkedin.com/in/kedar-pande

[BenJB]

Thank you so much, i have been struggling with this for over an hour and you answer it within a minute, brilliant!