Slicer values

[Anonymous]

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.

[AlB]

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]

Thanks @AIB that will not work, I'm trying to capture all the selected values from the slicer, not just one value.

[AlB]

@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.

[Anonymous]

I tried that, but could not get it to work. Here is my pbix. https://1drv.ms/u/s!AumyvtVXEve9jL5qyYXyHuHPeU5kZQ

[v-jiascu-msft · Accepted solution]

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