Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Multiples selected values to display as one specific text

Hi friends, I'm trying to get a text display in a card box, based on the filters that I'm choosing on the screen. But my problem is: when I choose a specific filter under a macro filter, my DAX...
SELECTEDVALUE
textdisplay
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi Anonymous ,

    I tried using the function ISFILTERED, even if the filters are on the same tables, and it did work here!
    This is my code:

    Cabeçalho =
    "LOGISTICS OVERVIEW "
    & "FEV"
    & " - "
    &
            IF(
                ISFILTERED(COLUMN 1);
                SELECTEDVALUE(COLUMN 1);
            SELECTEDVALUE(COLUMN 2))
Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi Anonymous , thank you for your reply,

Yes, both filters "Macro Markets" and "Market" are in the same table,

COLUMN 1 (MACRO)COLUMN 2 (MARKET)
INTERNATIONALAFRICA
INTERNATIONALEUROPE
INTERNATIONALEURASIA
INTERNATIONALASIA
INTERNATIONALAMERICA
HALALMIDDLE EAST



Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi Anonymous ,

I tried using the function ISFILTERED, even if the filters are on the same tables, and it did work here!
This is my code:

Cabeçalho =
"LOGISTICS OVERVIEW "
& "FEV"
& " - "
&
        IF(
            ISFILTERED(COLUMN 1);
            SELECTEDVALUE(COLUMN 1);
        SELECTEDVALUE(COLUMN 2))