Sum of table column does not show same value

[F_ON79]

I have the following sample dataset where the BEP columns are calculated values. Specifically for BEP ASP per SQM_New the values work on a row does not do so in the column in Power BI unless I filter the "Total Current Volume" to be >0. ASP is average selling price which is simply total net sales divide by the vol in square meters.  Even if this can be a workaround for a table, but it messes up my visualizations which still captures the wrong value. For e.g ASP should be $1.19 but it shows $0.2. Snapshot below with table and relationships. 

N.B: The formulas below work pretty well with another dataset (CombData) without any need for filtering volume, but somehow with another dataset by changing the variables I face this problem. I have already deleted all zero values from the dataset but the error still persists. Will greatly appreciate help! 

Dataset: 

Year	Month	Material Number	Total current Volume	Total current Net Sales	BEP_Vol SQM_NEW	BEP ASP per SQM_New	Profit Center Description	Length (m)	Width (m)
2023	January	XE002018226	877500	$335,207.40	283039.4531	$1.18	2330	10	0.018
2023	February	XE002018226	1022800	$390,979.90	329906.2708	$1.19	2330	10	0.018
2023	March	XE002018226	580200	$224,898.00	187144.7187	$1.20	2330	10	0.018
2023	April	XE002018226	830800	$318,897.50	267976.2708	$1.19	2330	10	0.018
2023	May	XE002018226	974400	$371,474.50	314294.75	$1.18	2330	10	0.018
2023	June	XE002018226	987100	$375,932.50	318391.1615	$1.18	2330	10	0.018
2023	July	XE002018226	647600	$250,998.80	208884.7292	$1.20	2330	10	0.018
2023	August	XE002018226	1173400	$451,714.60	378482.6146	$1.19	2330	10	0.018
	TOTALS			$2,720,103.20	2288119.97	$1.19

Formulas: 

BEP_Vol SQM_NEW = var _table = SUMMARIZE(BEP, BEP[Material Number],"_Value",BEP[BEP_Volume (SQM)] ) return IF(HASONEVALUE(BEP[Material Number]), BEP[BEP_Volume (SQM)], SUMX(_table,[_Value]))

BEP_Volume (SQM) = if( SUM(BEP[Total current Volume])>0, SUM(BEP[Total current Volume])*AVERAGE(PC2330SKUs[Length (m)])*AVERAGE(PC2330SKUs[Width (m)]),0)

Snapshot of Table with wrong value

Relationships in blue. *Combdata is a separate dataset that seems to work with the same formula. 

[lbendlin]

Not sure if the relationships are impacting anything but you want to use SUMX to have the right aggregation

see attached