Show card with text (return TRUE) based on slicer multiselection value.

[rmeng]

I want to display a card with text based on a true condition. In this case my measure returns FALSE:

2022 Q3 Selected Text =

IF(SELECTEDVALUE('CALENDAR'[Year Quarter]) in {"2022 Q3","2022 Q2","2022 Q4"},TRUE(),FALSE()).
Instead of False as displayed below I want a TRUE in case Year Quarter Multiselection contains 2022 Q3.

Could you give me some help?

Thanks

[johnt75]

You can't use SELECTEDVALUES if multiple values will be selected. Try

2022 Q3 Selected Text =
NOT ISEMPTY (
    INTERSECT (
        VALUES ( 'CALENDAR'[Year Quarter] ),
        { "2022 Q3", "2022 Q2", "2022 Q4" }
    )
)

[rmeng]

Thanks johnt75,

But If I don´t select "2022 Q3" the condition should be FALSE. Should be TRUE when <> then "2022 Q3" Else False.

[johnt75]

Try

2022 Q3 Selected Text = "2022 Q3" IN VALUES( 'CALENDAR'[Year Quarter])

[rmeng · Accepted solution]

Thanks,

I´ve found the solution:

                IF(

                    CONTAINS(

                        'CALENDAR',

                        'CALENDAR'[Year Quarter],"2022 Q3"

                    ),

                        TRUE(),

                        FALSE()

                )