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.
-LIST("")
at the end of your expression, also donโt use SPLIT() here.
Can I exclude specific values as well this way?
And if so.....what am I doing wrong in my statement?
The "Exclude this value" keeps popping up in my generated list
UNIQUE(Registration[Destination]) - LIST("Exclude this value") |
Thank you @Bahbus!
Also, I thought I should be using SPLIT() anytime I retrieve EnumList of Ref. Why is SPLIT not necessary here?
SELECT() naturally returns everything as a List. No need to further split it. Split is only sometimes with finicky EnumList columns where the data is already stored. And even then, itโs only sometimes needed.
LIST(โโโ) to be added at the end of select().please ?
User | Count |
---|---|
38 | |
27 | |
23 | |
23 | |
13 |