Good day, how can i achieve filtering the ref...

[Jessrhyl_Longay]

Good day, how can i achieve filtering the ref column in other forms that it is used?

[Levent_KULACOGL]

@Jessrhyl_Longay

In your ref column’s Valid_if you can use a SELECT expression:

SELECT(TableName[KeyColumnName],NOT(IN([LookupColumn],TableName[KeyColumnName])))

[Aleksi_Alkio]

And in generally… SELECT(TableName[KeyColumnName],YourOwnEvaluation)

[Jessrhyl_Longay]

@Levent_KULACOGLU this was what i did. thanks