want sum of estimated hours,for every employee , task-wise

[jay_patel]

Hello All

I just want a another calculated column with 65, i.e sum of estimated hours , task no wise.. for every employee

18+15+32 = 65

employee	Task No		Estimated Hours
MAHAVIRSINH PARMAR	430		18
MAHAVIRSINH PARMAR	433		32
MAHAVIRSINH PARMAR	433		32
MAHAVIRSINH PARMAR	433		32
MAHAVIRSINH PARMAR	433		32
MAHAVIRSINH PARMAR	433		32
MAHAVIRSINH PARMAR	433		32
MAHAVIRSINH PARMAR	234		15
MAHAVIRSINH PARMAR	433		32
MAHAVIRSINH PARMAR	234		15
MAHAVIRSINH PARMAR	234		15
MAHAVIRSINH PARMAR	234		15

[Jihwan_Kim · Accepted solution]

Hi, @jay_patel 

Please try the below.

New Column =

SUMX(SUMMARIZE('Table', 'Table'[employee],'Table'[Task No], 'Table'[Estimated Hours]), 'Table'[Estimated Hours])

Hi, My name is Jihwan Kim.

If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

Linkedin: https://www.linkedin.com/in/jihwankim1975/