Hi All,
I have a column EnumList of type Ref where I use AUTO COMPUTE > Suggested values with the following code:
SPLIT(
SELECT(
Objective_Completion_Logs[Working_Teaching_Tips]
,
AND(
ISNOTBLANK(Working_Teaching_Tips)
,
[Objective]=[_THISROW].[Objective_1]
)
,
TRUE
)
,
","
)
In the Select condition, I exclude rows that have their column Working_Teaching_Tips empty. However, when the user clicks on the column to see the list of suggested values, an empty option is displayed. The good thing is that it disappears if I try to select any options (see video).
Do you have any recommendation in changing the expression above to avoid seeing this glitch?
Solved! Go to Solution.
-LIST("")
at the end of your expression, also donโt use SPLIT() here.
User | Count |
---|---|
18 | |
11 | |
7 | |
4 | |
3 |