Dynamic calculation based in two different tables

Hello again community. 

I only come here when I have tried all I know and also tried to search some solution in many places. Sometimes we have a very specific challenge that needs special and focused help. Or maybe the solution is so simple, but I am blind and complicating the situation.

What I need?: Define this year annual Billing target based on an evolution (last year over projection of this year) result from another table. If you prefer, I am sharing in my One Drive the .pbix file called "SampleData_ModifiedNumbers" + a simple print with desired outcome. Link to sample data

Inside dashbord I have Measure items A, B, C, D and E and wrong / correct outcome:

• Measures A, B, C and D come from a table called Pilot (table A); 
• Measure E comes from a table called MiddleOffice (table B); 
• Wrong Outcome card is a measure where I am trying to get an outcome combining two other results (from table A and table B). 
• Correct Outcome card is a representation of what I expect to see when I try to automate. Here I am hardcoding 0,0583. 

Basically I want to subtract Item D from Item E to get this year target, but I need to have this automatically according to Year and Pilot Base slicers. So, if you select 2018 and 4 we have an Evolution of 5,83%. If you select 2018 and 3 now we have 5,89% and so on. 

*** DAX measures: 

Item A:

Billing Pilot Last Year = 
VAR BRL =
    IF (
        HASONEVALUE ( 'Date'[Year] );
        CALCULATE (
            SUM ( Pilot[SELL_BILLINGS_LCY] );
            ALL ( Pilot[PILOT BASE] );
            SAMEPERIODLASTYEAR ( 'Date'[Date] );
            Pilot[FINAL PILOT BASE] = "YES"
        );
        BLANK ()
    )
VAR EUR =
    IF (
        HASONEVALUE ( 'Date'[Year] );
        CALCULATE (
            SUM ( Pilot[SELL_BILLINGS_LCY_EUR] );
            ALL ( Pilot[PILOT BASE] );
            SAMEPERIODLASTYEAR ( 'Date'[Date] );
            Pilot[FINAL PILOT BASE] = "YES"
        );
        BLANK ()
    )
RETURN
    IF (
        HASONEVALUE ( 'Currency'[Currency] );
        SWITCH ( VALUES ( 'Currency'[Currency] ); "BRL"; BRL; "EUR"; EUR; BRL );
        BRL
    )

Item B:

Billing Pilot = 
IF (
    HASONEVALUE ( 'Currency'[Currency] );
    SWITCH (
        VALUES ( 'Currency'[Currency] );
        "BRL"; [Billing Pilot _BRL];
        "EUR"; [Billing Pilot _EUR]
    );
    [Billing Pilot _BRL]
)


Sub DAXs:

Billing Pilot _BRL = SUM( Pilot[SELL_BILLINGS_LCY])

Billing Pilot _EUR = SUM( Pilot[SELL_BILLINGS_LCY_EUR])

Item C:

Billing Pilot Evolution ABS = IF (
    HASONEVALUE ( 'Currency'[Currency] );
    SWITCH (
        VALUES ( 'Currency'[Currency] );
        "BRL"; [Billing Pilot Evolution ABS BRL];
        "EUR"; [Billing Pilot Evolution ABS EUR]
    );
    [Based 2017 Global Obj Bil _PilotEvoImpact BRL]
)


Sub DAXs:

Billing Pilot Evolution ABS BRL = [Billing Pilot _BRL] - [Billing Pilot Last Year _BRL]

Billing Pilot Evolution ABS EUR = [Billing Pilot _EUR] - [Billing Pilot Last Year _EUR]

Item D: 

Billing Pilot Evolution % = 
IF (
    HASONEVALUE ( 'Currency'[Currency] );
    SWITCH (
        VALUES ( 'Currency'[Currency] );
        "BRL"; [Billing Pilot Evolution % BRL];
        "EUR"; [Billing Pilot Evolution % EUR]
    );
    [Billing Pilot Evolution % BRL]
)


Sub DAXs: 

Billing Pilot Evolution % BRL = DIVIDE([Billing Pilot _BRL] - [Billing Pilot Last Year _BRL]; [Billing Pilot Last Year _BRL];0)

Billing Pilot Evolution % EUR = DIVIDE([Billing Pilot _EUR] - [Billing Pilot Last Year _EUR]; [Billing Pilot Last Year _EUR];0)

Item E:

Based LY Realized Act Bil = 
IF (
    HASONEVALUE ( 'Currency'[Currency] );
    SWITCH (
        VALUES ( 'Currency'[Currency] );
        "BRL"; [Based LY Realized Act Bil BRL];
        "EUR"; [Based LY Realized Act Bil EUR];
        [Based LY Realized Act Bil BRL]
    );
    [Based LY Realized Act Bil BRL]
)


Sub DAXs: 

Based LY Realized Act Bil BRL = 
CALCULATE (
    SUM ( MiddleOffice[BILLING BRL] );
    ALL ( 'Date'[Year] );
    SAMEPERIODLASTYEAR ( 'Date'[Date] )
)


Based LY Realized Act Bil EUR = 
CALCULATE (
    SUM ( MiddleOffice[BILLING EUR] );
    ALL ( 'Date'[Year] );
    SAMEPERIODLASTYEAR ( 'Date'[Date] )
)

WRONG Outcome: 

Based LY Realized Obj Bil _PilotEvoImpact ### WRONG ### = 
IF (
    HASONEVALUE ( 'Currency'[Currency] );
    SWITCH (
        VALUES ( 'Currency'[Currency] );
        "BRL"; [Based LY Realized Obj Bil _PilotEvoImpact BRL ### WRONG ###];
        "EUR"; [Based LY Realized Obj Bil _PilotEvoImpact EUR ### WRONG ###];
        [Based LY Realized Obj Bil _PilotEvoImpact BRL ### WRONG ###]
    );
    [Based LY Realized Obj Bil _PilotEvoImpact BRL ### WRONG ###]
)


Sub DAXs: 

Based LY Realized Obj Bil _PilotEvoImpact BRL ### WRONG ### = 
CALCULATE (
    SUM ( MiddleOffice[BILLING BRL] );
    ALL ( 'Date'[Year] );
    SAMEPERIODLASTYEAR ( 'Date'[Date] )
)
    - CALCULATE (
        SUM ( MiddleOffice[BILLING BRL] );
        ALL ( 'Date'[Year] );
        SAMEPERIODLASTYEAR ( 'Date'[Date] )
    )
        * [PilotImpact BRL]  <<<<<< PROBLEM IS HERE


Based LY Realized Obj Bil _PilotEvoImpact EUR ### WRONG ### = 
CALCULATE (
    SUM ( MiddleOffice[BILLING EUR] );
    ALL ( 'Date'[Year] );
    SAMEPERIODLASTYEAR ( 'Date'[Date] )
)
    - CALCULATE (
        SUM ( MiddleOffice[BILLING EUR] );
        ALL ( 'Date'[Year] );
        SAMEPERIODLASTYEAR ( 'Date'[Date] )
    )
        * [PilotImpact EUR]  <<<<<< PROBLEM IS HERE

 Correct Outcome: 

Based LY Realized Obj Bil _PilotEvoImpact = 
IF (
    HASONEVALUE ( 'Currency'[Currency] );
    SWITCH (
        VALUES ( 'Currency'[Currency] );
        "BRL"; [Based LY Realized Obj Bil _PilotEvoImpact BRL];
        "EUR"; [Based LY Realized Obj Bil _PilotEvoImpact EUR]
    );
    [Based LY Realized Obj Bil _PilotEvoImpact BRL]
)


Sub DAXs: 

Based LY Realized Obj Bil _PilotEvoImpact BRL = 
CALCULATE (
    SUM ( MiddleOffice[BILLING BRL] );
    ALL ( 'Date'[Year] );
    SAMEPERIODLASTYEAR ( 'Date'[Date] )
)
    - CALCULATE (
        SUM ( MiddleOffice[BILLING BRL] );
        ALL ( 'Date'[Year] );
        SAMEPERIODLASTYEAR ( 'Date'[Date] )
    )
        * VALUES ( PilotEvolution_Table[% Evolution] )  <<<< I can't use this way (hardcoding using a disconnected slicer)


Based LY Realized Obj Bil _PilotEvoImpact EUR = 
CALCULATE (
    SUM ( MiddleOffice[BILLING EUR] );
    ALL ( 'Date'[Year] );
    SAMEPERIODLASTYEAR ( 'Date'[Date] )
)
    - CALCULATE (
        SUM ( MiddleOffice[BILLING EUR] );
        ALL ( 'Date'[Year] );
        SAMEPERIODLASTYEAR ( 'Date'[Date] )
    )
        * VALUES ( PilotEvolution_Table[% Evolution] )  <<<< I can't use this way (hardcoding using a disconnected slicer)

Thanks a lot and I hope you have a better idea :smileylol:

Jimmy