Show an specific message in card visual when I have a blank value in the column

[Anonymous]

Hi guys,

Iam Triying to return a scroll message "Não Ha correlação de máquinas" when the column BNEF_Standardised_turbine_name  = blank .... but it working fine inside the column but when I try to use scroll card it not works.

follow my dax column : 

mensagem máquinas sem correlação =

IF (

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

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

    ""

)

Any suggestion to help me with that?
Thx

[amitchandak · Accepted solution]

@Anonymous , select blank or no value selected  ?

IF (
isblank(SELECTEDVALUE(Merge1[BNEF_Standardised_turbine_name])),
"Não há correlação de máquinas",
""
)

nothing is selected

IF (
calculate(isfiltered(Merge1[BNEF_Standardised_turbine_name]), allselected(Merge1) ),
"Não há correlação de máquinas",
""
)

[Anonymous · Accepted solution]

Hi @Anonymous ,

It seems that what you are creating is a calculated column, as the Category field of Scroller visual only can put the fact field or calculated column. And since what you created is a calculated column, it will not change according to the user interaction(slicer, filter, column selections etc.) in the report as the value of a calculated column is computed during data refresh and uses the current row as a context... Please review the following links about the difference of calculated column and measure...

Calculated Columns and Measures in DAX

Calculated Columns vs Measures

So if you want to get the dynamic value base on the selected values, you need to create a measure as below to replace the original calculated column. Then create a card visual to replace the scroller visual. Please see the details in the page named "Measure" of the attachment.

mensagem máquinas sem correlação = 
IF (
    SELECTEDVALUE ( Merge1[BNEF_Standardised_turbine_name] ) = BLANK (),
    "Não há correlação de máquinas",
    ""
)

Best Regards

[amitchandak · Accepted solution]

@Anonymous , select blank or no value selected  ?

IF (
isblank(SELECTEDVALUE(Merge1[BNEF_Standardised_turbine_name])),
"Não há correlação de máquinas",
""
)

nothing is selected

IF (
calculate(isfiltered(Merge1[BNEF_Standardised_turbine_name]), allselected(Merge1) ),
"Não há correlação de máquinas",
""
)