exclude columns while sum

[Anonymous]

I need to sum of column 'Value' but ignoring last two columns. The result should bne 75000 because all

ProjectName	CaseId	FacilityType	HCType	SystemName	ResourceName	Year	Value	ConversionValue	scenarioid	Esc_Index
GKR	3	WHP	Oil	Gas Manifolding and Separation	Control valves 4" above per valve service	2023	75000	96.47659	2	209.61973
GKR	3	WHP	Oil	Gas Manifolding and Separation	Control valves 4" above per valve service	2023	75000	96.47659	3	205.27884
GKR	3	WHP	Oil	Gas Manifolding and Separation	Control valves 4" above per valve service	2023	75000	96.47659	4	201.84359

[amitchandak · Accepted solution]

@Anonymous , based on what I got , try a measure like

sumx(summarize(Table, [ProjectName],[CaseId],[FacilityType],[HCType],[SystemName],[ResourceName],[Year],[Value]),[Value])

add or reduce group by in summarize

[Anonymous]

Its working but slow. is there any other workaround.