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

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)

0 2 334
2 REPLIES 2

tony1
Participant V

@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], โ€ฆ))

@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]

Top Labels in this Space