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
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
Anonymous It is working! Thanks!!
Is there a way that it could work without adding the measure in the table?
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.ThanksIt makes lots of sense!
Thank you so much Anonymous for your time and help!!
Anonymous In case of having 2 Slicers for 2 diffirent columns like this:
2 Slicers for two different columns
Is there a way where I can show values that is only have both filters apply as in AND between first values and seconds values? As a hierarchy filter maybe?Thanks!
- You could add measure like this:Filter Found Measure4 =var text_to_find = SELECTEDVALUE(Table4[Column1])var text_to_find2 = SELECTEDVALUE(Table5[Column1])var text_to_search = MAX(Table3[Column1])VAR FIND_RES = FIND(text_to_find,text_to_search,1,BLANK())VAR FIND_RES2 = FIND(text_to_find2,text_to_search,1,BLANK())return IF(FIND_RES >= 1 && FIND_RES2 >= 1 , text_to_search)And result would be like thisdid you mean this?But please ensure that the filters are applied from different tables. Otherwise it won't work.Hope this helps,Let me know if it meets your requirement.Thanks.
Thanks a lot Anonymous !!