Filter an Ref enum of another table

[gadiepe]

I´m trying to select only the contacts that are set as "User" in the table of "Events", I´ve tried with diferent functions... but no mater what i put always returns all of the "Conctact list".

This are some of the expressions I have tried:

1.  Filter(
               "Contactos",
                ISNOTBLANK(
                                           Contactos[Es usuario]
                                           )
                )

2.  Select(
                   Contactos[ID],
                   ISNOTBLANK(
                                              Contactos[Es usuario]
                                               )
                   )

3.  Filter(
               "Contactos",
                Contactos[Es usuario]="Si"
                )

In #3, cant do it because appears: "Cannot compare List with Text in (Contactos[Es usuario] = "Si")", I´ve tried with: TEXT(Contactos[Es usuario]) = "Si" but nothing...

• Table where the colum with a ref enum is set: "Evento" (event)
• Colum where the ref enum is set: "Vendedor" (Saller)
• Ref table to enum: "Conctactos" (Contacts)
• Colum in the table "Contactos" that determines the parameter: "Es Usuario" (Is user)
• Colum data type "Es usuario": "Enum" whith the only value "Si" (yes)

[Suvrutt_Gurjar]

Please try in the valid_if of the reference column:

Filter(
               "Contactos",
                [Es usuario]="Si"
                )

Or please simply try: 

Filter(
               "Contactos",
                [Es usuario]
                )

The assumption is you are trying this in the valid_if of the reference column in the "Evento" table where you are referencing the Contactos table.  [Es usuario] is assumed to be Y/N type column or enum column with options "Si" and "No"