topic Re: Show card with text (return TRUE) based on slicer multiselection value. in DAX Commands and Tips

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

rmeng — Mon, 14 Nov 2022 10:16:01 GMT

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

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

johnt75 — Mon, 14 Nov 2022 12:21:05 GMT

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" } ) )

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

rmeng — Mon, 14 Nov 2022 12:57:07 GMT

Thanks johnt75,

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

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

johnt75 — Tue, 15 Nov 2022 11:06:47 GMT

Try

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

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

rmeng — Tue, 15 Nov 2022 13:54:54 GMT

Thanks,

I´ve found the solution:

IF(

CONTAINS(

'CALENDAR',

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

TRUE(),

FALSE()

)