Forum Discussion
Using Text Filter for exact match
lkshck , When you use search in Normal slicer, that it force selection of exact value (Option under three dots)
lkshck Well, you could create your own measure for filtering. I call them Complex Selectors:
Basically in your case maybe a slicer with the words and then something like:
Selector Measure =
VAR __Value = SELECTEDVALUE('Slicer'[Value])
RETURN
IF(MAX('Table'[Column]) = __Value, 1, 0)
Trying to use your dax to build my expression. I'm using the Microsoft Text Filter visual to find an exact match for a birth date. There is a table visual in the report which will show the employee and birth exact match. If no exact match, no employees should show.
All birthdays in the dataset are text fields formatted as 6 characters, 010176.
I'm not sure how to apply the selected value to the search box. Do I filter for 1? Or 0? On the search box or the visual table in the report? Any help would be great.
Selector Measure =
VAR __Value = SELECTEDVALUE(TABLE[BBD)
RETURN
IF(LEN(__Value) = 6 && MAX(TABLE[BBD) = __Value, 1, 0)