topic Sum of values with condition in another column in DAX Commands and Tips

Sum of values with condition in another column

Syl4 — Mon, 26 Aug 2024 10:20:38 GMT

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 🙂

Re: Sum of values with condition in another column

Rupak_bi — Mon, 26 Aug 2024 10:29:46 GMT

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.

Re: Sum of values with condition in another column

dharmendars007 — Mon, 26 Aug 2024 10:40:51 GMT

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

Re: Sum of values with condition in another column

Syl4 — Mon, 26 Aug 2024 11:15:22 GMT

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.