Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreShape the future of the Fabric Community! Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions. Take survey.
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
Solved! Go to Solution.
hi, @augustindelaf
Try this formula:
Selected PDLs= CONCATENATEX ( VALUES ( Data[Nationality] ) , [Nationality] , ",")
Best Regards,
Lin
@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)
Proud to be a PBI Community Champion
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
hi
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
hi, @augustindelaf
Try this formula:
Selected PDLs= CONCATENATEX ( VALUES ( Data[Nationality] ) , [Nationality] , ",")
Best Regards,
Lin
This is what I needed...thank you so much!!
@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 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)
Proud to be a PBI Community Champion
Not working when selectint single value for me
How do I display "All Months" when all or none of the months are selected?
it works fine, thank you!
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])
Hi @Anonymous
it is an old request that I made,
i don't remember the use case it was necessary for.
Anyways, thank you.
@PattemManohar thanks for the reply !
i think it works but I used another formula :
Label - Selected Nationality =
IF(
COUNTROWS( VALUES( Data[Nationality] ) ) ❤️
; CONCATENATEX(VALUES( Data[Nationality] ); Data[Nationality]; ", " )
; "Multiple Selection"
)
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
@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
Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.
User | Count |
---|---|
92 | |
92 | |
84 | |
80 | |
49 |
User | Count |
---|---|
146 | |
137 | |
109 | |
68 | |
55 |