Urgent Help Needed with DAX query in Power BI

[Anonymous]

Hello all,
I have fact table "Test" and one disconnected table "Language".
Language table has contry and languagecode column where Belgium has two languagecode . we have RLS applied on this so that customer sees only their country language type in slicer .

So if customer selects languageType "nl-be" then it should filter responses for both language code "nl-be" and "en".
Similarly, on selection of "fr-be", data should filter for "fr-be" and "en".

Below is the sample data of Fact table

I have written below DAX measure to achieve this which works fine on latest data where we added translation for response .

ResponseTranslation =

SWITCH(SELECTEDVALUE('Language'[LanguageType]),

"nl-be",MAXX(FILTER(Test,Test[languagecode] IN {"nl-be","en"}),Test[response]),

"fr-be",MAXX(FILTER(Test,Test[languagecode] IN {"fr-be","en"}),Test[response]),

MAX(Test[response]))

The problem is with historical data where we don't have translation available and hence the languagecode either blank or doesn't match with latest languagecode in fact table so they see all responses data only if they don't select any LanguageType.

Requirement :

For old data, they want to see all responses (whatever is there in system) data irrespective selection of LanguageType but response column can't be blank in table on selection of fr-be or nl-be.
However, It shows data when you don't select any languagetype for historical records but they want to select one of the lanuage type always and it can't be blank . (Language Type might be replaced with radio button in future)

This is for recent data result which is fine (I have used DAX measure in table insetad of response column)

 For old data it should show everything on selection of any language type

I am looking forward to hear from you all. Please help me with this requirement / share idea how to achieve this please
Thanks in advance!

[AlexisOlson · Accepted solution]

What if you inverted the logic and told it what not to include?

SWITCH (
    SELECTEDVALUE ( 'Language'[LanguageType] ),
    "nl-be", CALCULATE ( MAX ( Test[response] ), Test[languagecode] <> "fr-be" ),
    "fr-be", CALCULATE ( MAX ( Test[response] ), Test[languagecode] <> "nl-be" ),
    MAX ( Test[response] )
)

[Anonymous]

@AlexisOlson Great ! Thanks very much it's working abosultely fine with test data .
I will try in my real power bi dataset. 
Thanks a lot for solution . Very much appreciated !