Forum Discussion
Text Filter Facing conundrum!!
I am using Text Filter Visual to filter out values in a table and the SELECTEDVALUE function shows the output based on it.
The input is name of a person in the text filter, and if the name is found then the output, in a separate card, is the name of the person. The measure for the output is:
It is working for most of the cases. However, when I type in a name like 'John' when there is 'Johnson' or 'Johny' also available, it return blank because SELECTEDVALUE has a property where it returns the value when the context for columnName has been filtered down to one distinct value only, Otherwise returns alternateResult.
Note that it would return available when searched for Johnson or Johny, as there is no conflict (non-distinct values) there.
Can I get the desired output on this? I don't want to change the input type, i.e., it has to stay as text filter.
7 Replies
Thank you for the response.
By this, I am getting output as 'Johnson, Johny, John', rather than 'John'
John is a separate row entry under the column 'name' in the 'Table 1'. Similarly, Johnson and Johny are also separate entries.
I want that if I enter John in Text filter, I get only John. Right now, I am getting Blank, as John is not treated as distinct entries by SELECTEDVALUE function.
But when I enter Johnson or Johny, I get them respectivaly as the output as they are treated as Distinct entries.
In case, user searches for anything that is not available in the column 'name', it should return a 'blank' only.
So if only John, Johnson and Johny are there in the table, and if I search for johns, it should return a 'blank'.
