Forum Discussion
Solved
Filtering a column with delimiter
Hello, I have a basic table (T1) as shown on the left, I want to be able to filter the rows based on the three available values: A, B, and C. For example if I choose "C" from the filter the table wil...
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
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 this
did 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 !!