topic Re: Card value is blank when multiple selections in a slicer in DAX Commands and Tips

Card value is blank when multiple selections in a slicer

Anonymous — Tue, 27 Oct 2020 08:03:41 GMT

Hello!

I'm wondering if it's possible to add a condition and how would it look like that if multiple selections were made to a slicer it shows a blank for this card?

EURO-Emission classification =
SWITCH (

TRUE();

vehiclesettings_BI_LL[Year] < 1992; "No Year";

vehiclesettings_BI_LL[Year] <= 1997 && vehiclesettings_BI_LL[MonthNumber] <= 10; "Euro 1";

vehiclesettings_BI_LL[Year] <= 1998 && vehiclesettings_BI_LL[MonthNumber] <= 10; "Euro 2";

vehiclesettings_BI_LL[Year] <= 2000 && vehiclesettings_BI_LL[MonthNumber] <= 10; "Euro 3";

vehiclesettings_BI_LL[Year] <= 2005 && vehiclesettings_BI_LL[MonthNumber] <= 10; "Euro 4";

vehiclesettings_BI_LL[Year] <= 2008 && vehiclesettings_BI_LL[MonthNumber] <= 10; "Euro 5";

vehiclesettings_BI_LL[Year] <= 2013 && vehiclesettings_BI_LL[MonthNumber] <= 12; "Euro 5";
"Euro 6")

Re: Card value is blank when multiple selections in a slicer

dedelman_clng — Tue, 27 Oct 2020 14:02:20 GMT

Hi Anonymous -

Use HASONEVALUE( )

IF ( HASONEVALUE ( vehiclesettings_BI_LL[Year] ),

SWITCH(

.... ,

"Euro 6"),

"") //ELSE

Note, this will also show "" if 0 slicer selections are made.

Hope this helps

David

Re: Card value is blank when multiple selections in a slicer

Anonymous — Tue, 27 Oct 2020 16:48:54 GMT

I tried using this syntax but it changed all of my Euro values inside the column to Blank and the card also shows Blank as the answer if only one vehicle was selected. Could the problem be that this is a calculated column instead of a measure?

EURO-Emission classification =

IF(HASONEVALUE(vehiclesettings_BI_LL[Year]);

SWITCH (

TRUE();

vehiclesettings_BI_LL[Year] < 1992; "No Year";

vehiclesettings_BI_LL[Year] <= 1997 && vehiclesettings_BI_LL[MonthNumber] <= 10; "Euro 1";

vehiclesettings_BI_LL[Year] <= 1998 && vehiclesettings_BI_LL[MonthNumber] <= 10; "Euro 2";

vehiclesettings_BI_LL[Year] <= 2000 && vehiclesettings_BI_LL[MonthNumber] <= 10; "Euro 3";

vehiclesettings_BI_LL[Year] <= 2005 && vehiclesettings_BI_LL[MonthNumber] <= 10; "Euro 4";

vehiclesettings_BI_LL[Year] <= 2008 && vehiclesettings_BI_LL[MonthNumber] <= 10; "Euro 5";

vehiclesettings_BI_LL[Year] <= 2013 && vehiclesettings_BI_LL[MonthNumber] <= 12; "Euro 5";

vehiclesettings_BI_LL[Year] <= 2014; "Euro 6");

"Blank")

Re: Card value is blank when multiple selections in a slicer

dedelman_clng — Tue, 27 Oct 2020 16:52:30 GMT

Anonymous - if you want any value to change with a slicer, it must be a measure. Calculated columns are only refreshed once when the entire dataset is refreshed.

If you're still having trouble, please share a copy of your PBIX file with sensitive data scrubbed out.

David

Re: Card value is blank when multiple selections in a slicer

Anonymous — Tue, 27 Oct 2020 18:02:04 GMT

I changed my syntax to work in a measure and now it works as intended. Thank you for your help!