display sum of subroup on every row?

[Anonymous]

How can I display the below table in a pbix?

Parent	Client	Value	Sum Of The Parent
1	1	5	68
1	2	51	68
1	3	12	68
2	4	1	3
2	5	1	3
2	6	1	3

I have the data for Parent,Client and Value... but I am trying to display the same for the same parent on all rows...

[PijushRoy]

Hi @Anonymous 

Can you please try 

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

[amitchandak]

@Anonymous , If you need sum of parent

You can get a new measure

= calculate(sum(Table[Value]), filter(allselected(Table), Table[Parent] = max(Table[Parent]) ) )