Is It Possible to Add New Entry (Other than Listed from Select Option) if I am Using SELECT Formula in Valid_If
Instead of using SELECT formula in Valid_If, you could use it with the Suggested_Values. Though if you are using Enum or EnumList, you can set the option “Allow other values” as ON.
I tried your Suggestion but it is Showing All Entries of That Column
I only want limited Entries that Match
SELECT(Sales[Bag Roll Size], ([_THISROW].[Job Name]=[Lisence Ptg.]))
If the option “Auto-complete other values” is ON, it will read your existing values from this column and show them in your dropdown. If you set that option as OFF, it will not show those values.