Forum Discussion
vishal0soni
Advocate III
Advocate IIIFilter / Display rows based on substring present within a slicer
I have a list of items (Apple, Bat, Cherry, Dog, and Elephant). One or more of these items may or may not appear in the list of multiple comma-separated keywords (Apple, Cherry, Elephant). What i n...
I think I got the easiest way of doing this just by using SEARCH function.
We can write this measure:
Exists = SEARCH(
SELECTEDVALUE('Products'[Product]),
SELECTEDVALUE(Solution_Products[SolutionProducts]),
,-1)And then use this as a filter criterion for displaying the values.It works perfectly fine as desired.Ritaf1983 I got it. Used SEARCH function in a measure, and then used that in the filter.
Ritaf1983
Super User
Super Uservishal0soni Unfortunately I don't think we have another kind of solution, that's necessary to make the relationship...same logic as lookup.
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
vishal0soniAdvocate III
Advocate IIICan we make use of string functions like FIND or SEARCH dynamically to obtain the desired results on the fly?
- Ritaf1983
vishal0soni I don't see how it can work with the slicers...
but you can try to play with it...- vishal0soni
Ritaf1983 I got it. Used SEARCH function in a measure, and then used that in the filter.