Connecting values from measures

Hi Anonymous ,

Here we go:

Table = 
VAR k =
    SUMMARIZE (
        'Sales (table1)',
        'Sales (table1)'[CustID],
        'Sales (table1)'[Year],
        'Sales (table1)'[Season],
        'Sales (table1)'[ProductType],
        "date", MAX ( 'Sales (table1)'[EntryDate] )
    )
VAR fil =
    ADDCOLUMNS (
        k,
        "Gross Sales LE", CALCULATE (
            SUM ( 'Sales (table1)'[Gross Sales LE (EUR)] ),
            FILTER ( 'Sales (table1)', 'Sales (table1)'[EntryDate] = [date] )
        ),
        "NetSalesPerc_", 1
            -
            VAR kk =
                ADDCOLUMNS (
                    'SalesPerc (table2)',
                    "maxd", CALCULATE (
                        MAX ( 'SalesPerc (table2)'[EntryDate] ),
                        ALLEXCEPT (
                            'SalesPerc (table2)',
                            'SalesPerc (table2)'[CustID],
                            'SalesPerc (table2)'[Year],
                            'SalesPerc (table2)'[Season],
                            'SalesPerc (table2)'[ProductType]
                        )
                    )
                )
            VAR fi =
                FILTER ( kk, 'SalesPerc (table2)'[EntryDate] = [maxd] )
            RETURN
                CALCULATE (
                    SUM ( 'SalesPerc (table2)'[NetSalesPerc] ),
                    FILTER (
                        'SalesPerc (table2)',
                        'SalesPerc (table2)'[CustID] = 'Sales (table1)'[CustID]
                            && 'SalesPerc (table2)'[Year] = 'Sales (table1)'[Year]
                            && 'SalesPerc (table2)'[Season] = 'Sales (table1)'[Season]
                            && 'SalesPerc (table2)'[ProductType] = 'Sales (table1)'[ProductType]
                    ),
                    KEEPFILTERS ( fi )
                ),
        "ProfitPerc_",
        VAR newk =
            ADDCOLUMNS (
                'SalesPerc (table2)',
                "maxdd", CALCULATE (
                    MAX ( 'SalesPerc (table2)'[EntryDate] ),
                    ALLEXCEPT (
                        'SalesPerc (table2)',
                        'SalesPerc (table2)'[CustID],
                        'SalesPerc (table2)'[Year],
                        'SalesPerc (table2)'[Season],
                        'SalesPerc (table2)'[ProductType]
                    )
                )
            )
        VAR fi =
            FILTER ( newk, 'SalesPerc (table2)'[EntryDate] = [maxdd] )
        RETURN
            CALCULATE (
                SUM ( 'SalesPerc (table2)'[ProfitPerc] ),
                FILTER (
                    'SalesPerc (table2)',
                    'SalesPerc (table2)'[CustID] = 'Sales (table1)'[CustID]
                        && 'SalesPerc (table2)'[Year] = 'Sales (table1)'[Year]
                        && 'SalesPerc (table2)'[Season] = 'Sales (table1)'[Season]
                        && 'SalesPerc (table2)'[ProductType] = 'Sales (table1)'[ProductType]
                ),
                KEEPFILTERS ( fi )
            )
    )
VAR c =
    ADDCOLUMNS ( fil, "gro", [NetSalesPerc_] * [Gross Sales LE] )
VAR d =
    ADDCOLUMNS ( c, "a", [ProfitPerc_] * [gro] )
RETURN
    SELECTCOLUMNS (
        d,
        "id", 'Sales (table1)'[CustID],
        "year", 'Sales (table1)'[Year],
        "Seadon", 'Sales (table1)'[Season],
        "Porduct type", 'Sales (table1)'[ProductType],
        " Net Sales", [gro],
        "Gross Margin", [a],
        "Gross Sales LE", [Gross Sales LE]
    )

For more details, please check the pbix as attached.