Power BI Average measure seems to ignore dates

I am new to both Power BI and Stack Overflow, but I am having a bit of trouble getting an AVERAGE measure to work on my data in Power BI.

I have a table of products with pricing for myself and the difference in price for two competitors, and I have a date slicer which uses the date of the corresponding Monday for each date. I want my table to show the average price difference for each competitor during the week selected in the slicer.

The problem is that upon selecting a week date in the slicer, the average values for Competitor 1 and Competitor 2 are not correct.

I have created a measure for each competitor that looks like this:

Most Recent Diff Competitor 1 = 
VAR MinDate = MIN('Calendar'[WeekStartDate])
VAR MostRecentDate = 
    CALCULATE(
        MAX(pricetracker_price_history[date]),
        REMOVEFILTERS('Calendar'[WeekStartDate]),
        pricetracker_price_history[date]<MinDate,
        pricetracker_price_history[Competitor 1]<>BLANK()
    )
VAR MostRecentDiff = 
    IF(
        AVERAGE(pricetracker_price_history[Competitor 1])<>BLANK(),
        AVERAGE(pricetracker_price_history[Competitor 1]),
        IF(MostRecentDate<>BLANK(),
            CALCULATE(
                AVERAGE(pricetracker_price_history[Competitor 1]),
                REMOVEFILTERS('Calendar'[WeekStartDate]),
                pricetracker_price_history[date]=MostRecentDate
            ),
            COUNTBLANK(pricetracker_price_history[Competitor 1])-COUNTBLANK(pricetracker_price_history[Competitor 1]) //This was to give 0 instead of blank spaces
        )
    )
RETURN MostRecentDiff

The idea is that if there is no price difference given in the table for a particular date, then the price difference should be taken as the most recent non-blank value prior to that date.

My tables look like this (truncated here):

pricetracker_price_history

Calendar

Upon selecting WeekStartDate as 22/07/2024 in the slicer, the visualisation gives:

when I would expect it to be

I'm struggling to see why the average is not being taken over just the dates with WeekStartDate = 22/07/2024.

Any help would be greatly appreciated!

I think you should get the correct answer. Have you create the relationship between two tables (Connecting date columns)

Then create two measures

Measure = AVERAGE(pricetracker_price_history[Competitor 1])
measure2 = average(pricetracker_price_history[Competitor 2])