I have two stand-alone tables:

'Data' with columns [Label] text, [Year] integer, [Location] text, [Value] integer.

'Label_List' with column [Label] text. (list of distinct [Label] column seen in 'Data' table.)

In 'Data' table, each [Label] can have data for multiple years and multiple locations.

I have a user selected value for 'Label_List'[Label] from a slicer.

In the visualization I am trying to compare each [Label] (row) to the slicer selected [Label]. I am struggling to calculate and display the [Value] average for each [Label] row by row, with using only the specific subset of [Value] values that have overlapping combinations of [Year] and [Location] with the slicer selected [Label]. This is the "Label Average Overlap" in the Visualization example table.

I have had success with writing the code for the other overlap column. For example:

Selected Label Average Overlap = 
CALCULATE(
    AVERAGE(Data[Value]),
    Data[Label] = SELECTEDVALUE(Label_List[Label]),
    Data[Year] IN VALUES(Data[Year]) && Data[Location] IN VALUES(Data[Location])
)

I have struggled with writing the code for the "Label Average Overlap"

Label Average Overlap = 

VAR SlicerLabel = SELECTEDVALUE(Label_List[Label])
VAR DataLabelRow = SELECTEDVALUE(Data[Label]) 

VAR CommonYearsAndLocations =
    CALCULATETABLE(
        VALUES(Data[Year]),
        FILTER(
            Data,
            COUNTROWS(
                FILTER(Data, Data[Year] = EARLIER(Data[Year]) && Data[Location] = EARLIER(Data[Location]) && Data[Label] = DataLabelRow)
            ) > 0 &&
            COUNTROWS(
                FILTER(Data, Data[Year] = EARLIER(Data[Year]) && Data[Location] = EARLIER(Data[Location]) && Data[Parent] = SlicerLabel)
            ) > 0
        )
    )

RETURN
    CALCULATE(
        AVERAGE(Data[Value]),
        Data[Label] = SlicerLabel,
        Data[Year] IN CommonYearsAndLocations,
        Data[Location] IN VALUES(Data[Location]) 
    )

'Label_List' Table

'Data' Table

Table Visualization: Example where Label A is selected in the slicer. All values compare to Label A.