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
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
It makes lots of sense!
Thank you so much Anonymous for your time and help!!