Forum Discussion
Solved
Filter / 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.
vishal0soni 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
Can we make use of string functions like FIND or SEARCH dynamically to obtain the desired results on the fly?
vishal0soni I don't see how it can work with the slicers...
but you can try to play with it...Ritaf1983 I got it. Used SEARCH function in a measure, and then used that in the filter.