Sum of values with condition in another column

[Syl4]

Hello team, 

I'd like to calculate the sum of the task duration for each project mentioned in the PROJECT NAME column. 

Is it something possible in PowerBI please ? 

Here is my table to ease understanding. 

I'd like to create the column named "Sum of durations for each project" without adding a condition on the project name because there are tens of projects.

PROJECT NAME	Phase	taskDuration	Sum of durations for each project
Project1	Phase1	3	57
Project1	Phase1	49	57
Project1	Phase1	5	57
Project1	Phase2	25	87
Project1	Phase2	62	87
Project1	Phase3	2	2
Project1	Phase3	0	2
Project1	Phase4	29	43
Project1	Phase4	7	43
Project1	Phase4	7	43
Project1	Phase5	42	42
Project22	Phase1	60	80
Project22	Phase1	20	80
Project22	Phase2	30	67
Project22	Phase2	2	67
Project22	Phase2	25	67
Project22	Phase2	10	67
Project22	Phase3	5	15
Project22	Phase3	10	15
Project22	Phase4	20	26
Project22	Phase4	3	26
Project22	Phase4	3	26
Project22	Phase5	50	50

For now, I didn't succeed 😐.

Thanks for your advices 🙂

[Syl4]

Perfect, thank you !

I'm too new in PowerBI, not clear to me how it works for now, but I'm going to check that deeper. 

[dharmendars007]

Hello @Syl4 , 

Please try this measure , this should work...

Project_Group =

                CALCULATE(SUM('Table'[taskDuration]),

                            ALLEXCEPT('Table',

                            'Table'[PROJECT NAME], 'Table'[Phase]))

If you find this helpful , please mark it as solution and Your Kudos are much appreciated!

Thank You

Dharmendar S

LinkedIN 

[Rupak_bi · Accepted solution]

here is your solution:

Calculated duration = calculate(sum('Table (3)'[taskDuration]),ALLEXCEPT('Table (3)','Table (3)'[PROJECT NAME],'Table (3)'[Phase]))

if this is what you want, plz accept as solution.