Forum Discussion
ALLSELECTED with multiple selection doesnt work
Hebj 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.
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.
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.
I just realized my misunderstanding here... Of course - a measure can only return a scalar value. I need to think of another solution then. Thanks for taking your time!