DAX virtual summarized table

See if this works for you:

% Yield Val = 
AVERAGE('Table'[% Yield])

Overall Yield =
AVERAGEX (
    SUMMARIZE (
        'Table',
        'Dim Die'[DIE_TYPE],
        'Dim Flow'[D flow],
        'Dim Ft Product'[FT_PRODUCT],
        'Dim Insertion'[D Insertion],
        'Dim Lot'[LOTNO],
        'Table'[Insertion Temp]
    ),
    [% Yield Val]
)

Yield By Lot =
VAR Lot =
    MAX ( 'Dim Lot'[LOTNO] )
RETURN
    IF (
        ISBLANK ( [% Yield Val] ),
        BLANK (),
        AVERAGEX (
            FILTER ( ALL ( 'Table' ), RELATED ( 'Dim Lot'[LOTNO] ) = LOT ),
            [% Yield Val]
        )
    )

Yield Change = [Overall Yield] - [Yield By Lot]

I've attached the sample BPBIX file

Hi Paul,

I was out for a few days, i tried your code yesterday, and it works.

Thank you very much

Regadrs,

Karim