How to compare two information from 2 differentes table

[Frdric]

Hello, I have a problem creating a slice to make a filtered view by user. To provide context, I have two tables.

Table 1: Users, on this table I have email addresses next to sector codes

Table 2: 'Sites' I have site names next to sector codes

I can't find a way to display the sites according to the user's email address. I've tried searching the forum but I haven't found my solution.

Thank you in advance, have a good day

[TeeSee1]

Look for information on Label and/or Dereference in the help document.

[Steve]

This?

([codesect] = LOOKUP(USEREMAIL(), "Table 1", "mail", "codesect"))

[Frdric]

That's what I need, however, I have a problem with the result. The formula only displays one matching value.

The problem is that I would like to display all the sites with their different sector codes, but the formula only shows me one matching value. Would it work better if I use the "Any" function?

Thank you for your help.

[Steve · Accepted solution]

Try this instead:

IN(
  [codesect],
  SELECT(
    Table 1[codesect],
    (USEREMAIL() = [mail])
  )
)

[Frdric]

Thank you so much i was searching for at least a day on this !🙏