Why when I change the column to summaize by sum the related result has been double?

[TungNguyen_19]

Hello guys

I have these 2 tables like below:

The fomular of the calculated column [TOTAL ESTIMATE COST] is 

[TOTAL ESTIMATE COST] = RELATED('TABLE A'[ESTIMATE COST])

 When i put the column [TOTAL ESTIMATE COST] in table visual with option summarized by sum, the value will be double but if I change to don't summarized option the value return to correct number (same value from 'TABLE A'[ESTIMATE COST] )

Anybody know what happen here? I need the Total Summarize below of Table visual so I turn on this options. I have try to use Measure like this but the error still happen:

Measure Total Estimate Code = SUM([TOTAL ESTIMATE COST])

 Many thanks ❤️ 

[amitchandak · Accepted solution]

@TungNguyen_19 , This may be level you want sum is different from you rowlevel you can try like

Sumx(Summarize(Table, Table[Item], Table[TOTAL ESTIMATE COST]), [TOTAL ESTIMATE COST])

Or add more columns from visual

Sumx(Summarize(Table, Table[Item], Table[SKU], Table[TOTAL ESTIMATE COST]), [TOTAL ESTIMATE COST])

[TungNguyen_19]

Thank you, after I use your fomular for my measure with ID key of table look like it return correct value now