topic Re: Multiples selected values to display as one specific text in DAX Commands and Tips

Multiples selected values to display as one specific text

Anonymous — Wed, 25 Jan 2023 15:41:39 GMT

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 formula keeps me returning the macro and not the specific filter.

For instance:

I would like to display "AMERICA" instead of "INTERNATIONAL", but the value "AMERICA" belongs to "INTERNATIONAL".

My measure is currently:

DisplayText = "LOGISTICS OVERVIEW FEV - " &

IF(

SELECTEDVALUE( COLUMN 1 ) = "INTERNATIONAL"

;

"INTERNATIONAL"

;

IF(

SELECTEDVALUE( COLUMN 1 ) = "HALAL";

"HALAL"

;

SELECTEDVALUE(COLUMN 2)

)

The table structure is basically:

COLUMN 1 (MACRO)	COLUMN 2 (MARKET)
INTERNATIONAL	AFRICA
INTERNATIONAL	EUROPE
INTERNATIONAL	EURASIA
INTERNATIONAL	ASIA
INTERNATIONAL	AMERICA
HALAL	MIDDLE EAST

Does anyone know how to fix this?

Thanks!

Re: Multiples selected values to display as one specific text

Anonymous — Tue, 31 Jan 2023 07:21:29 GMT

HI Anonymous,

Did these filter use the same table field as source? AFAIK, current power bi filters does not support to get different values from the filters that used same table feild as source .

If they are from different fields, you can use ISFILTERED function to trace the selections and as conditions to use in if statements.

ISFILTERED function (DAX) - DAX | Microsoft Learn

Notice: current power bi use 'AND' logic to link different filters, if you want to achieve some customize filter effects, please create unconnected tables(not has relationship to current table relationships) as source of filter.

Regards,

Xiaoxin Sheng

Re: Multiples selected values to display as one specific text

Anonymous — Tue, 31 Jan 2023 20:17:05 GMT

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)
INTERNATIONAL	AFRICA
INTERNATIONAL	EUROPE
INTERNATIONAL	EURASIA
INTERNATIONAL	ASIA
INTERNATIONAL	AMERICA
HALAL	MIDDLE EAST

Re: Multiples selected values to display as one specific text

Anonymous — Tue, 31 Jan 2023 20:36:45 GMT

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))