Calculate Average Data based on Filters

Hi there,

I am trying to create two sets of data for comparison, one based on a single table the other based on values from two tables.
These tables are imported via SQL Database through power query. I have no direct access to modify / create tables in the SQL databases so hoping to do this in Power BI.

Table 1 - Predictions
Predicted condition over a range of years (full dataset has a range of 20 years)

Table 2 - Area
Table that stores standardised area across the database.

The tables are in a relationship based on the UIDX field.

I would like to calculate the following:
Query 1 - Average 'condition' - result to be displayed in a card using the following criteria:

• Where Scenario = 0
• And yr = 2021

e.g. cond_avg = CALCULATE(AVERAGE(predictions[condition]),FILTER(predictions,predictions[yr] = "2021"))

I used a New Measure to try and calculate Query 1. It initially appeared fine but when I add the results to a card I get the following error, interestingly the columns are both format Decimal Number.:
Calculation error in measure 'predictions'[cond_avg]: DAX comparison operations do not support comparing values of type Number with values of type Text. Consider using the VALUE or FORMAT function to convert one of the values.

Query 2 - Average condition x Area - display average condition multiplied by area in a card based on the following criteria:

• Where Scenario = 0
• And yr = 2021

I have tried to get a result from joining tables thought have been unsuccessful. I am trying to replicate the following (assume the query 1 will need to be integrated?):
Sum(predictions[condition]*area[area])/sum(area[area])

Is anyone able to assist? Thanks in advance!