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
That's correct -
You don't need the third table.
You can have one table that will contain your different filtering possibilities and another table with the text that you want to analyze. It doesn't matter where you create the measure, in terms of functionality, but it would make the most intuitive sense to include it in the table that contains the text like "ABC".
Then, add the new measure to the table visual to cause the filter affect.
Does it make sense?
Nathan
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 :)