Exclude e certain value from a Reference Dropdown

[sorin_mihai]

Hello,

I have a Category Table and a Projects Table.
The Projects table has a column named Project Category, which references the Category Table.
There are three rows in the Category Table and so in the Form of a project, the Project Category Dropdown displays these three values.
How can I make this dropdown display only two of these values? without erasing the row from the Category Table itself.

I tried putting this in the Valid if of the Projects Category column but it doesn’t work…:
[Project Category]<>“ValueNotWanted”

Thank you,
Sorin

[LeventK · Accepted solution]

@sorin_mihai
Valid_if

SELECT(Projects[Key], NOT([Project Category]=“ValueNotWanted”))

[sorin_mihai]

Thank you

[LeventK]

You’re very welcome

[LeventK]

@sorin_mihai
Also provided the unwanted value in not falling into the middle when you sort that column in ascending or descending order, you can also use one of these:

TOP(
	ORDERBY(
		SELECT(Projects[Key],TRUE,TRUE), //cosntruct the list
		[Project Category], //as per this column
		FALSE //sort in ascending order
	),
	2 //return top 2 values
)

OR

TOP(
	ORDERBY(
		SELECT(Projects[Key],TRUE,TRUE), //construct the list
		[Project Category], //as per this column
		TRUE //sort in descending order
	),
	2 //return top 2 values
)