Forum Discussion
Solved
display multiple elements with SELECTEDVALUE
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 "Fr...
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)
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
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 ?
- What I did :Selected Nationality =IF(COUNTA( VALUES < 2;CONCATENATEX ( VALUES ( Data[Nationality] ) ; Data[Nationality] ; ", ");"Multiple Selection"))But it does not work
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)
This is what I needed...thank you so much!!