SUM value based on multiple columns

[BeeleJa]

Hi all, I am trying to add a column that is representing the sum of only one of the repeating values within a certain number of rows that are part of a defined hoger level of rows.

Basically for all the same 'CASEID'I only want to use Hours once and create a column tht represents the total hours on 'Main_WO' level. The output I am looking for is shown in Table Column "MainWo_Total_HRS"

Row dat typically represents all kind of different Item ID's 

Main_WO	EPCAMCASEID	Appl_Lab_Hours_ProjID	MainWO_Total_HRS	Rowdata
W0003447	W0003447	117.01	156.44	1
W0003447	W0003447	117.01	156.44	2
W0003447	W000344701	39.43	156.44	17
W0003447	W000344701	39.43	156.44	18
W0003447	W000344701	39.43	156.44	19
W0003447	W000344701	39.43	156.44	150
W0003447	W00034470101	0	156.44	151
W0003447	W00034470101	0	156.44	152
W0003447	W00034470102	0	156.44	157
W0003447	W00034470102	0	156.44	158
W0003447	W00034470103	0	156.44	164
W0003447	W00034470103	0	156.44	165
W0003447	W00034470103	0	156.44	170
W0003447	W00034470104	0	156.44	171
W0003447	W00034470104	0	156.44	172
W0003447	W00034470104	0	156.44	173
W0003447	W00034470105	0	156.44	174
W0003447	W00034470106	0	156.44	175
W0003447	W00034470108	0	156.44	176
W0003447	W00034470109	0	156.44	177
W0003447	W00034470109	0	156.44	178
W0004034	W0004034	148.1	218.89	182
W0004034	W0004034	148.1	218.89	183
W0004034	W0004034	148.1	218.89	184
W0004034	W0004034	148.1	218.89	283
W0004034	W000403401	37.06	218.89	284
W0004034	W000403401	37.06	218.89	285
W0004034	W000403401	37.06	218.89	286
W0004034	W000403401	37.06	218.89	367
W0004034	W000403401	37.06	218.89	368
W0004034	W000403401	37.06	218.89	369
W0004034	W00040340101	0	218.89	370
W0004034	W00040340101	0	218.89	371
W0004034	W00040340101	0	218.89	372
W0004034	W00040340102	0	218.89	379
W0004034	W00040340103	0	218.89	380
W0004034	W00040340105	0	218.89	381
W0004034	W00040340106	0	218.89	382
W0004034	W00040340106	0	218.89	383
W0004034	W00040340108	0	218.89	384
W0004034	W00040340108	0	218.89	385
W0004034	W00040340108	0	218.89	386
W0004034	W00040340108	0	218.89	387
W0004034	W00040340109	0	218.89	388
W0004034	W00040340109	0	218.89	389
W0004034	W00040340110	0	218.89	396
W0004034	W00040340112	0	218.89	397
W0004034	W00040340112	0	218.89	398
W0004034	W00040340112	0	218.89	412
W0004034	W00040340113	0	218.89	413
W0004034	W000403402	33.73	218.89	414
W0004034	W000403402	33.73	218.89	415
W0004034	W000403402	33.73	218.89	503
W0004034	W000403402	33.73	218.89	504
W0004034	W000403402	33.73	218.89	505
W0004034	W00040340201	0	218.89	506
W0004034	W00040340201	0	218.89	509
W0004034	W00040340202	0	218.89	510
W0004034	W00040340203	0	218.89	511
W0004034	W00040340204	0	218.89	512
W0004034	W000403403	0	218.89	513
W0004034	W000403404	0	218.89	514
W0004034	W000403404	0	218.89	515
W0004034	W000403404	0	218.89	520
W0004034	W000403405	0	218.89	521
W0004034	W000403405	0	218.89	522
W0004034	W000403405	0	218.89	523
W0004034	W000403405	0	218.89	524

[DataInsights · Accepted solution]

@BeeleJa,

Try this calculated column:

MainWo_Total_HRS = 
VAR vMainWO = WorkOrders[Main_WO]
VAR vMainWOTable =
    FILTER ( WorkOrders, WorkOrders[Main_WO] = vMainWO )
VAR vDistinctCaseID =
    SUMMARIZE (
        vMainWOTable,
        WorkOrders[EPCAMCASEID],
        WorkOrders[Appl_Lab_Hours_ProjID]
    )
VAR vResult =
    SUMX ( vDistinctCaseID, WorkOrders[Appl_Lab_Hours_ProjID] )
RETURN
    vResult