topic Display a selection data in a card with an "IF" function in DAX Commands and Tips

Display a selection data in a card with an "IF" function

Anonymous — Thu, 11 May 2023 08:32:49 GMT

Hi everyone,

I would like to know certainly something easy and simple ...

The objective is to display in a card the data "Name of Brand" that is selected in the filter "Brand" otherwise, if no selection then diplay a blanck.

Is it possible to do a dax formula with " (Brand[Name of Brand] is not selected, "", [Brand of name])

Thank you in advance for your help,

Léna

Re: Display a selection data in a card with an "IF" function

Anonymous — Thu, 11 May 2023 08:52:43 GMT

I am back with a solution that works :

Mesure = if(ISFILTERED('Brand'[Name of brand]),FILTERS('Brand'[Name of brand]),"")

Maybe we can optimise it ?

Re: Display a selection data in a card with an "IF" function

FreemanZ — Thu, 11 May 2023 08:57:17 GMT

hi Anonymous

try to plot a measure like:

Measure =
IF(
SELECTEDVALUE(data[brand])=BLANK(),
"",
SELECTEDVALUE(data[brand])
)