Forum Discussion
Filtering a column with delimiter
It is not possible. But I could suggest you to modify the measure so that directly you can refer measure instead of the column. But there must be atleast a column from the table which you are searching.
Try this formula,
Filter Found Measure3 =var text_to_find = SELECTEDVALUE(Table2[Column1])var text_to_search = MAX(Table3[Column2])VAR FIND_RES = FIND(text_to_find,text_to_search,1,BLANK())return IF(FIND_RES >= 1, text_to_search)Now you no need to worry about hiding.Let me know if it is making sense.Thanks
Thank you again @natelpeterson!
I've made the new measure in the first table (the one I want to ably the filter on)
But adding the measure as the Slicer value isn't possible, I think I'm missing something :) Is it the relationship?
Current Relationship
When I choose 'A' as the filter value, I only got rows with 'A' only, instead of any row that contain an 'A'.
Current Report After Choosing 'A'
Most appreicated!
There is no need of adding relationship. You are referring the filter column in measure. So can you remove the filter and try?
Hey Anonymous Thank you so much for your replay!
Still the Slicer isn't accepting the measure Filter as a value
Try this and add this measure and T1[Values] column to visual without adding relationship to tables.
Filter Found Measure =
var text_to_find = SELECTEDVALUE(T2[Column2])
var text_to_search = MAX(T1[Values])
return FIND(text_to_find,text_to_search,1,BLANK())Hi Anonymous The slicer still doesn't take the measure as vlaue :)
I was able to filter. Are you adding the measure to visual?
It's working