Applying Equipment Costs to My Project Column

Hi v-chenwuz-msft ,
I was hoping you could look at my revised file & Data structure as i believe i am almost there.
https://1drv.ms/u/s!Aqcds9Zosni5iGg4Q6QZYRSbaWJc?e=s00mzY  

I have changed the structure of My Data & combined many similiar lookup tables into 1 so im no longer running into the previous issue; my current issue is as follows:

the i want to filter the following calculation to only sum "AVG. plant & Vehicle cost per day" values where Day diary plant days in the adjacent column <> 0 :

Values of Calculations Below:

Total Project cost for Plant = DayDiaryPlantList_Sharepoint[Day Diary Plant Days] * SUM(Plant[AVG. Plant & Vehicle Cost Per day])

 

 

 

in the above example, i would like the following values applied to  applied to the top table; so instead of total project plant cost for the selected item equalling $1921.39 i would want it to equal  $85.87 and applied to the project above.

 

i have tried a few calculations such as:

TEST = Calculate(SUM(Plant[AVG. Plant & Vehicle Cost Per day]),DayDiaryPlantList_Sharepoint[Day Diary Plant Days]<>0)

but it returns the following error:

A function 'PLACEHOLDER' has been used in a True/False expression that is used as a table filter expression. This is not allowed.

 

Plant_Name	Day Diary Plant Days	AVG plant &	Total Project cost for plant
Plant item 1	2	$30.48	$60.97
Plant item 2	2	$12.45	$24.90
TOTAL			$85.87