Does anyone know a way to return all of the distinct values in a column via a slicer selection. I understand how to do this using measures e.g if “Revenue” is selected then return revenue. However, what I am wondering is if the user selects from a slicer “Paint” or “Style” it will return all the different styles that are in my table, e.g. if paint is picked it will return:
Yellow… anything that is in my data table.
I am trying a few methods but I keep receiving “multiple values returned when one value is expected error”
Any Ideas how I might implement this?