Solved: How to compare two information from 2 differentes ... - Page 2

Frdric · 01-24-2025 02:39 AM

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

Steve

Try this instead:

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

How to compare two information from 2 differentes table