Can't achieve SUM within group

[Anonymous]

I can't achieve the last column "Sum Of The Parent":

Parent	Client	Value	Sum Of The Parent
1	1	5	68
1	2	51	68
1	3	12	68
2	4	9480	29608
2	5	20000	29608
2	6	128	29608

Like above... My goal is to display the SUM for where parent =1, for where parent =2 and so on...

How can I achieve it in DAX?

[PijushRoy]

Hi @Anonymous 

Can you please try below DAX for measure

Measure = CALCULATE(
    SUM('Table'[Value]),
    ALLEXCEPT('Table','Table'[Parent]))

If solve the requirement, please mark this answer as a solution.

[lukiz84]

Hi,

do you want it as a column or a measure?

[Anonymous]

It doesnt matter as long as I can display it in a table like the above...

I think it has to be a column for it to work...