display multiple elements with SELECTEDVALUE

[augustindelaf]

Hello,

I am using the DAX measure SELECTEDVALUE to display the value of a column that is filtered in a table visual.

But I can't find a way to display multiple elements.

For instance, if "France" is selected in the field 'Data'[Nationality], the DAXmeasure SELECTEDVALUE will display "France", and that is good. (SelectedNationality = SELECTEDVALUE(data[Nationality])

But if I select "France" and "Italy" in this filed, I would like that my measure displays both "France" and "Italy".

Any idea HOW ?

Best regards

Augustin

[v-lili6-msft · Accepted solution]

hi, @augustindelaf 

Try this formula: 

Selected PDLs=
CONCATENATEX ( VALUES ( Data[Nationality] ) , [Nationality] , ",")

Best Regards,

Lin

[OwenAuger]

Hello Augustin,

I think CONCATENATEX is going to do what you want. CONCATENATEX iterates over a table and concatenates a text expression evaluated for each row of the table. In particular, you can use CONCATENATEX with VALUES to concatenate distinct values from a column.

You could write a measure like this to create a comma-separated string of Nationality values.

SelectedNationalities =
CONCATENATEX (
    VALUES ( data[Nationality] ),
    ", "
)

Is that what you were looking for?

Regards,

Owen

[augustindelaf]

hi 

@OwenAuger 

It would be perfect but it doesn't work.

My measure (exactly the one you wrote) is not in error, and it finds the field nationality but the only value that is displayed is the Comma.

2 values selected

[v-lili6-msft · Accepted solution]

hi, @augustindelaf 

Try this formula: 

Selected PDLs=
CONCATENATEX ( VALUES ( Data[Nationality] ) , [Nationality] , ",")

Best Regards,

Lin

[IXESA]

This is what I needed...thank you so much!!

[augustindelaf]

@v-lili6-msft  I also need to display "Multiple Selection" IF the Concatenex values are more than 2.

Than means :

1 selection = [Selection1]

2 selections =[Selection1] ", " [Selection2] 

3 sleections and more = "Multiple Selection"

how can I do that, please ?

[augustindelaf]

What I did :

Selected Nationality =

IF(COUNTA( VALUES < 2;

CONCATENATEX ( VALUES ( Data[Nationality] ) ; Data[Nationality] ; ", ")

;"Multiple Selection"

))

But it does not work

[PattemManohar · Accepted solution]

@augustindelaf  Please try this in your measure..

MonthSelection = 
VAR _Count = COUNTROWS(VALUES(_Date[Month]))
VAR _Concat = CONCATENATEX(VALUES(_Date[Month]),[Month],",")
RETURN IF(_Count>2,"Multiple Selection",_Concat)

[Sindhuja22]

Not working when selectint single value for me 

[lluser]

How do I display "All Months" when all or none of the months are selected?

[Anonymous]

it works fine, thank you!

[Anonymous]

Make Variable in DAX , Give any name like "My Selection" then 

Make small dimension table (Measure Selection) with your selected Measure name and use it in DAX.

Here is Formula : I have three measure and I made a table with three name and used in DAX

DAX :

Selected Measure:= Var MySelection = CALCULATE(ALLSELECTED('Measure Selection'[Measure Name ]))
RETURN SWITCH( TRUE(),MySelection = "Discharge",[Discharge Count],MySelection="Admission",
[Admission Count],MySelection="Patient Days",[Patient Days],[Discharge Count])

[augustindelaf]

Hi @Anonymous 

it is an old request that I made,

i don't remember the use case it was necessary for.

Anyways, thank you.

[augustindelaf]

@PattemManohar thanks for the reply !

i think it works but I used another formula :

Many thanks anyway

Label - Selected Nationality = 
IF(
     COUNTROWS( VALUES( Data[Nationality] ) ) ❤️ 
    ; CONCATENATEX(VALUES( Data[Nationality] ); Data[Nationality]; ", " )
    ; "Multiple Selection"
)

[augustindelaf]

many thanks @v-lili6-msft !

it works now 🙂

very nice from you

[v-lili6-msft]

hi, @augustindelaf 

SELECTEDVALUE returns the value when the context for columnName has been filtered down to one distinct value only. Otherwise returns alternateResult.

So you could just need to use IN and VALUES instead of SELECTEDVALUE

For example:

(SelectedNationality IN VALUES(data[Nationality])

Best Regards,

Lin

[augustindelaf]

@v-lili6-msft could you please write the exact measure ?

I wrote the one you gave me but it didn't work.

Many thanks in advance.

Best regards,

Augustin