NON-related Slicer (multi selection problem)

Hi Dog, how are you? Thanks a lot for your reply...

Yeah, you are right. Easiest way :smileylol:, but in my case I will have another issue. Let me try to give full scenario. Maybe you can get the picture and help me with a kind of "manual summation" using a slicer that do not intefere in a another measure in the same visual (in this case a table or matrix). 

• I have two different tables called MiddleOffice and Pilot; 
• They have a common column called "Pure Player" (which are AFFIPERF, MOBEXT, ECSELIS and SOCIALYSE); 
• As far as I know, with the scenario below I cannot relate both Tables (Middle Office and Pilot) because If I do I will not be able to prevent Filter Context in all measures participating in the same visual, right?; 

I am sharing Files:

• Sample file .pbix;
• Tables_MiddleOffice & Pilot (relationship print screen);
• Visual_Using_MiddleOffice & Pilot Tables_1 (Final visual print screen with notes). 

*** From Pilot table I have measures: 

YTD FO (freezed) = Billings Jan17-Sep17 EXCEPT AFFIPERF, MOBEXT, ECSELIS and SOCIALYSE. Slicer CANNOT interfere!;

FC FO (freezed) = Forecast Oct17-Dec17 EXCEPT AFFIPERF, MOBEXT, ECSELIS and SOCIALYSE.  Slicer CANNOT interfere!;

FC MO (freezed) = Forecast Oct17-Dec17 JUST FOR AFFIPERF, MOBEXT, ECSELIS and SOCIALYSE. Slicer CANNOT interfere!;

FC PP (flexible) = Forecast Oct17-Dec17 ACCORDING TO slicer. If all selected result will be = FC MO. Slicer HAS TO interfere!;

*** From MiddleOffice table I have measures:

YTD MO = Billings Jan17-Sep17 JUST FOR AFFIPERF, MOBEXT, ECSELIS and SOCIALYSE. Slicer CANNOT interfere!; 

YTD PP = Billings Jan17-Sep17  ACCORDING TO slicer. If all selected result will be = YTD MO. Slicer selection HAS TO interfere!;

Measures: 

*** YTD FO = 
IF (
    CALCULATE (
        [Invest Pilot BRL];
        ALLEXCEPT ( Pilot; Pilot[YEAR] );
		FILTER ( Pilot; Pilot[VEHICLE THROUGH] = "OTHERS" );
        FILTER ( Pilot; Pilot[MEDIA TYPE] = "MEDIA - ON" );
        FILTER ( 'Date'; 'Date'[Month Number] < MONTH ( TODAY () ) );
        FILTER (
            GlobalGroup;
            GlobalGroup[GLOBAL GROUP] <> "EXTERNAL"
                && GlobalGroup[GLOBAL GROUP] <> "MIDDLE OFFICE"
        )
    )
        = BLANK ();
    BLANK ();
    CALCULATE (
        [Invest Pilot BRL];
        ALLEXCEPT ( Pilot; Pilot[YEAR] );
        FILTER ( Pilot; Pilot[VEHICLE THROUGH] = "OTHERS" );
        FILTER ( Pilot; Pilot[MEDIA TYPE] = "MEDIA - ON" );
        FILTER ( 'Date'; 'Date'[Month Number] < MONTH ( TODAY () ) );
        FILTER (
            GlobalGroup;
            GlobalGroup[GLOBAL GROUP] <> "EXTERNAL"
                && GlobalGroup[GLOBAL GROUP] <> "MIDDLE OFFICE"
        )
    )
)
// According to PILOT data


*** YTD MO = 
IF (
    CALCULATE (
        [Mthy Bil];ALL(PurePlayers_NOT_Related);
        ALLEXCEPT ( MiddleOffice; MiddleOffice[YEAR FPM]; Client[CLIENT] );
        FILTER ( 'Date'; 'Date'[Month Number] < MONTH ( TODAY () ) );
        FILTER (
            GlobalGroup;
            GlobalGroup[GLOBAL GROUP] <> "EXTERNAL"
                && GlobalGroup[GLOBAL GROUP] <> "MIDDLE OFFICE"
        )
    )
        = BLANK ();
    BLANK ();
    CALCULATE (
        [Mthy Bil];ALL(PurePlayers_NOT_Related);
        ALLEXCEPT ( 'Date';'Date'[Year] );
        FILTER ( 'Date'; 'Date'[Month Number] < MONTH ( TODAY () ) );
        FILTER (
            GlobalGroup;
            GlobalGroup[GLOBAL GROUP] <> "EXTERNAL"
                && GlobalGroup[GLOBAL GROUP] <> "MIDDLE OFFICE"
        )
    )
)
// According to Tableau / IOMT data (MiddleOffice Table)


*** YTD PP = 
IF (
    NOT ( ISFILTERED ( PurePlayers_NOT_Related[PURE PLAYER] ) );
    BLANK ();
    CALCULATE (
        [Mthy Bil];
        FILTER ( 'Date'; 'Date'[Month Number] < MONTH ( TODAY () ) );
        FILTER (
            MiddleOffice;
            MiddleOffice[GLOBAL GROUP] <> "EXTERNAL"
                && MiddleOffice[GLOBAL GROUP] <> "MIDDLE OFFICE"
        )
    )
)


*** FC FO = 
IF (
    CALCULATE (
        [Invest Pilot BRL];
        ALLEXCEPT ( Pilot; Pilot[YEAR] );
        FILTER ( Pilot; Pilot[VEHICLE THROUGH] = "OTHERS" );
        FILTER ( Pilot; Pilot[MEDIA TYPE] = "MEDIA - ON" );
        FILTER ( 'Date'; 'Date'[Month Number] >= MONTH ( TODAY () ) );
        FILTER (
            GlobalGroup;
            GlobalGroup[GLOBAL GROUP] <> "EXTERNAL"
                && GlobalGroup[GLOBAL GROUP] <> "MIDDLE OFFICE"
        )
    )
        = BLANK ();
    BLANK ();
    CALCULATE (
        [Invest Pilot BRL];
        ALLEXCEPT ( Pilot; Pilot[YEAR] ); 
        FILTER ( Pilot; Pilot[VEHICLE THROUGH] = "OTHERS" );
        FILTER ( Pilot; Pilot[MEDIA TYPE] = "MEDIA - ON" );
        FILTER ( 'Date'; 'Date'[Month Number] >= MONTH ( TODAY () ) );
        FILTER (
            GlobalGroup;
            GlobalGroup[GLOBAL GROUP] <> "EXTERNAL"
                && GlobalGroup[GLOBAL GROUP] <> "MIDDLE OFFICE"
        )
    )
)
// According to PILOT data


*** FC MO = 
IF (
    CALCULATE (
        [Invest Pilot BRL];
        ALLEXCEPT ( Pilot; Pilot[YEAR] );
        FILTER ( Pilot; Pilot[VEHICLE THROUGH] = "PURE PLAYERS" );
        FILTER ( 'Date'; 'Date'[Month Number] >= MONTH ( TODAY () ) );
        FILTER (
            GlobalGroup;
            GlobalGroup[GLOBAL GROUP] <> "EXTERNAL"
                && GlobalGroup[GLOBAL GROUP] <> "MIDDLE OFFICE"
        )
    )
        = BLANK ();
    BLANK();
    CALCULATE (
        [Invest Pilot BRL];
        ALLEXCEPT ( Pilot; Pilot[YEAR] );
        FILTER ( Pilot; Pilot[VEHICLE THROUGH] = "PURE PLAYERS" );
        FILTER ( 'Date'; 'Date'[Month Number] >= MONTH ( TODAY () ) );
        FILTER (
            GlobalGroup;
            GlobalGroup[GLOBAL GROUP] <> "EXTERNAL"
                && GlobalGroup[GLOBAL GROUP] <> "MIDDLE OFFICE"
        )
    )
) // According to PILOT data


*** FC PP = 
IF (
    NOT ( ISFILTERED ( PurePlayers_NOT_Related[PURE PLAYER] ) );
    BLANK ();
    CALCULATE (
        [Mthy Bil];
        FILTER ( 'Date'; 'Date'[Month Number] >= MONTH ( TODAY () ) );
        FILTER (
            MiddleOffice;
            MiddleOffice[GLOBAL GROUP] <> "EXTERNAL"
                && MiddleOffice[GLOBAL GROUP] <> "MIDDLE OFFICE"
        )
    )
)

Thanks again in advance,