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)
@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], โฆ))
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]
User | Count |
---|---|
41 | |
31 | |
31 | |
16 | |
14 |