Forum Discussion
ALLSELECTED with multiple selection doesnt work
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?
Hebj why not you put a table visual and choose one column Value in it, the table will show only these values which are selected int the slicer. Why that wouldn't work?
I need to show "[Nothing selected]" when the user havent done a selection in the slicer. Im going to hide the slicers in a popup to save space on the page and when they are hidden I want to show lists of what the user have selected in one list per slicer. 9 times out of 10 the user hasent done a selection so the list normally only need to show 2 or 3 records while the slicers show 10 to 15 records to be usable, and it will be much clearer for the user if the list says [Nothing selected] instead of listing every record from the slicer. I dont want to go with the concatenated value since I believe a list will be much cleaner in the layout. If I have a concatenated value I need to make space so the user dont have to scroll if he/she selects several items.
Im thinking if it would be possible with a separate "Selection-table" containing the records from the slicer with an added "[Nothing selected]" row. Maybe I can build a measure that will do a selection on that table based on the key of the dimension records, adding a zero for the Nothing selected row.
