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

(Aparicio Piñeyrúa) #1

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)

(Tony Fader) #2

@Aparicio_Pineyrua1 Your filter condition will always evaluate to true, since [Zone 1] is always in the list LIST([Zone 1], …)

[_THISROW].[Zone 1] is the “Zone 1” column from the table that this formula is in.

[Zone 1] is the “Zone 1” column from the table you are selecting from

So, I’m guessing you want to make your formula IN([_THISROW].[Zone 1], LIST([Zone 1], …))

(Aparicio Piñeyrúa) #3

@tony

Well, Table 1

had [Zone 1] is Yes/No type column And Table 2 had columns that are Yes/No type to.

So I want to filter the rows of the Table 2

if any of thouse columns matches the value Yes of Table 1 [Zone 1]