DAX - Hide message card when any value is nos filtered

[Anonymous]

Hi, 

I have a dax measure to show an specific message on card when I have Blank values in manufacturer column inside the table,
But when a Filter nothing or I select two or more values without Blank value  this message shows on card but i Want to show nothing for this case.

My dax: 

IF (

    SELECTEDVALUE ( Merge1[Manufacturer] ) = BLANK (),

    "Não há correlação de máquinas",""

)

1- when a Filter nothing. Want to show nothing message for this case.

2- It's ok for one value with manufacturer no blank

3 - I select two or more values without Blank value  this message shows on card but i Want to show nothing for this case.

Someone could help me with that?

Thank you

[PowerBIEnthu · Accepted solution]

Add one more condition like below in your if else statement

 CALCULATE(
        INT ( NOT ( ISEMPTY( Manufaturer) ) ),
        TREATAS ( 
            VALUES ( Merge1[Manufaturer] ), 
            Merge1[Slicer] 
        )
    )>1

  then "Your Condition"

[bolfri · Accepted solution]

I think this DAX code solve your problem. You should put the messages that you want in each scenario.

DAX = 
    SWITCH(TRUE(),
        NOT(ISFILTERED(Merge1[Manufaturer])),"Nothing filtered",
        HASONEVALUE(Merge1[Manufaturer]), "One manufacturer",
        NOT(HASONEVALUE(Merge1[Manufaturer])), "Multiple values"
)

Scenario 1:

Scenario 2:

Scenario 3:

[PowerBIEnthu · Accepted solution]

Add one more condition like below in your if else statement

 CALCULATE(
        INT ( NOT ( ISEMPTY( Manufaturer) ) ),
        TREATAS ( 
            VALUES ( Merge1[Manufaturer] ), 
            Merge1[Slicer] 
        )
    )>1

  then "Your Condition"