Forum Discussion
Slicer values
Hello All, Is there a way to capture values from single slicer. Example: Values in Slicer (Multi Select) Value A Value B Value C Value D and so on. User Selects Value A, Value C, and Value D. Is there a way to capture those values? Because based on user selected values, I need to pass the values to measure.
Hi Anonymous,
You can use that in another measure. But if you'd like to output the result, you need some aggregation functions. Please try this one.
Measure = CONCATENATEX ( VALUES ( Sheet1[Column1] ), [Column1], "," )
Best Regards,
Dale
5 Replies
Hi Anonymous
Yes, by using for example
SELECTEDVALUE('Table'[Slicer]). This only works with one item selected though. It will return blank() otherwise.
If you use VALUES('Table'[Slicer]) you'll get a one-column table with the values selected in the slicer that you can then use in your measure.
Does that help? Otherwise, if you show what you want to do in your measure we could be more specific
Anonymous
Sure. Like I said, VALUES('Table'[Slicer]) will get you a one-column table with the all the values selected in the slicer that you can then use in your measure.
