Forum Discussion
Anonymous
3 years agoNot applicable
Slicers with Multiple Values Returning Distinct Lists
I have a table named "Change Requests" with columns "Title" and "Assigned To Full Name". I want to create a measure that will return a list of all "Title" values associated with the selected name(s) ...
v-yueyunzh-msft
Community Support
3 years agoHi , Anonymous
According to your description, you have a sliver , and you need to return a list of all "Title" values associated with the selected name(s) in the slicer.
First , in the measure we can not return a list , but we can define the list in the "var" as a parameter.
For your need , we can use the :
var _list = VALUES('Table'[Title])
This will retrun the current filter context's [Title] list.
Thank you for your time and sharing, and thank you for your support and understanding of PowerBI!
Best Regards,
Aniya Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Anonymous
3 years agoNot applicable
v-yueyunzh-msft Thanks for the suggestion. I will see what I can figure out.