Forum Discussion
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) in the slicer. If more than one name is selected, the measure should only return the "Title" values that all selected names are associated with.
How can I do this?
2 Replies
- v-yueyunzh-msft
Community Support
Hi , 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
v-yueyunzh-msft Thanks for the suggestion. I will see what I can figure out.
