If selected value (slicer) contains one in a multiple selection - Display text Alerts in cards !

[ING_BT]

Hello all! 

I have created a measure that I use as an "Alert message texte" that I put into a "card" visual. 

What it does? It should display the card (with its measure) if the selected country is ONE of the selected countries and the date is in the date range selected (seperate date slicer - calander date table of course). 

I have a market slicer (for example: Italy, France, Germany) 
For each countries I have a different alert message for different dates, they should be displayed if the selected date is anterior to:

France = 2021/02/10

Italy = 2021/06/15

Germany = 2021/05/20

Data alert_France =
Var Marketselected = SELECTEDVALUE('Regions&Markets'[UA - Market (D2C)])
return
IF(Marketselected="France | D2C",
IF(
FIRSTDATE(DimDate[Date]) < DATE(2021,02,10),
"France: 17.03.2021"
,""
),"")

As you can see, this should be working fine, and it does. However, in the case I select several countries, it will not display the alert as the selected value doesn't equal to only France. 

How can I write all the possible possibilities of selection: 

France

France + Germany

France + Germany + Italy

France + Italy

...

Imagine I have more than 3 countries (and I do), it's starts being really complicated 🙂 

Thank you for your kind help.

Best,

BT.

[DataInsights · Accepted solution]

@ING_BT,

Try this solution:

1. Sample data:

2. Create measure:

Data Alert = 
VAR vFirstDate =
    FIRSTDATE ( DimDate[Date] )
VAR vResult =
    CONCATENATEX (
        FactTable,
        IF (
            vFirstDate < FactTable[Alert Date],
            FactTable[Market] & ": " & FactTable[Alert Message]
        ),
        " | "
    )
RETURN
    vResult

3. Create visuals:

------------------------------------------------------

[ING_BT]

I reproduced your solution and it works perfectly fine !! I tend to forget that I can create tables to ease something like that. 

Thank you very much! 

Best,

BT