Not able t0 add measure value in to Custom column

[Anonymous]

Hi Experts,
I have a table as shown in the below:

I'm trying to insert sum of 10+15+28 =53 in to Z5.

So i'm  trying to create new Custom Column like:
NEW= IF(Table[C2]="Z5",Tot_A,Table[Amt])

where, Tot_A= Calculate(SUM(Table[Amt]),Table[C1]="A")

PLEASE LET ME IF THIS IS POSSIBLE WITH DAX OR IS THERE A OTHER WAY?

[amitchandak · Accepted solution]

@Anonymous , Try a new column like

if([C2]="Z5",sumx(filter(Table, [C1]="A"),[Amt]),[Amt])

if this does not work

Can you share sample data and sample output in table format?

[Anonymous]

Thank you @amitchandak 
It Worked!!