Forum Discussion
aa_KF
7 years agoHelper I
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...
- Anonymous7 years ago
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
Anonymous
7 years agoNot applicable
There is no need of adding relationship. You are referring the filter column in measure. So can you remove the filter and try?
aa_KF
7 years agoHelper I
Hey Anonymous Thank you so much for your replay!
Still the Slicer isn't accepting the measure Filter as a value