ALLSELECTED with multiple selection doesnt work

Question

I want to create a table that lists all selected items in a slicer. When there is no item selected in the list I want to show "No Selection". I believe my problem is to get ALLSELECTED to return multiple records when there is more then one selected (ALLSELECTED works fine when only one record is selected - how come?).

(It is possible to accomplish this with Concate and [New line] characters, but then I need to have word wrap on for the table which makes a long string seem like several selected items which I dont want.

https://drive.google.com/file/d/1VRE7n-aCIWOArsO71kHXYwo52JBVFOu7/view?usp=sharing

parry2k · Answer

Hebj&nbsp;check this blog post which I wrote few days ago and see if this can help.

hebj · Answer

Thanks for your suggestion. It seems very useful and Im sure I will use that in the future. But right now I want to show the selected values in a list - not concatenated.

parry2k · Answer

Hebj&nbsp;what you mean you wan to show selected value, if more than one value is selected, you have to show it as a concatenated string.

hebj · Answer

It might be my limited understanding of DAX that is the problem, but to me it seems that the selection in the slicer is values from column: 'Dimension'[Value]. All I want to do is list these values in that column. So why isnt that possible? ALLSELECTED returns a table as I understand it - why cant I use that table to populate the table control? Ive been trying to google this question but I cant find any answer to that.

parry2k · Answer

you can surely have list of those values but what you want to with those values. As you know allselected returns a table, either you can use that table in other measures or you can this to concatenate to show the list. Measures are always return scalar value. Question is how you want this allselected list to be used?

Forum Discussion

ALLSELECTED with multiple selection doesnt work

8 Replies

Related content

rankx multiple columns allselected

Optimize AllSelected

Multiple version selection

Filters not works while selecting multiple Period

button slicer single select allows for multiple selections