Filter e Select ( IF and OR )

Hi, I’m in need of help on this formula. I would like to make a free filter , for each selection bring me the information and multiple selections filter too

Try this:

AND(
  OR(
    ISBLANK([DataInicio]),
    ISBLANK(Data[DataIn]),
    ([DataInicio] >= MAX(Data[DataIn]))
  ),
  OR(
    ISBLANK([DataFinal]),
    ISBLANK(Data[DataOut]),
    ([DataFinal] <= MIN(Data[DataOut]))
  ),
  OR(
    ISBLANK(Data[StatusVista]),
    IN([StatusVista], Data[StatusVista])
  ),
  OR(
    ISBLANK(Data[NomeFuncionarioDT]),
    IN([NomeFuncionarioDT], Data[NomeFuncionarioDT])
  ),
  OR(
    ISBLANK(Data[Equipe]),
    IN([Equipe], Data[Equipe])
  )
)

See also:

2 Likes

Hi, how can I filter within the [REF_OrdemProducao] the [Desenh.o] that is part of the OrdemProducao and the [Pec.a] that is part of the [Desenh.o] ?

I do not understand your question.

sorry , really the question would not be valid for the application