Hi I am trying to filter 1 value from 1 colu...

[Aparicio_Pineyr]

Hi

I am trying to filter 1 value from 1 column in 1 table, that matches any true of 5 columns in another table. I try lots of formulas but have no chance. Any thoughts?

this is the formula that I been working on:

SELECT(Users[email], IN([Zone 1], LIST([Zone 1],[Zone 2],[Zone 3],[Zone 4],[Zone 5])),TRUE)