Forum Discussion

Hebj's avatar
Hebj
Frequent Visitor
6 years ago

ALLSELECTED with multiple selection doesnt work

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 mult...
Need Help
parry2k's avatar
parry2k
Super User
6 years ago

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

  • Hebj's avatar
    Hebj
    Frequent Visitor
    6 years ago

    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's avatar
      parry2k
      Super User
      6 years ago

      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.

      • Hebj's avatar
        Hebj
        Frequent Visitor
        6 years ago

        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.