Create Slice based on USEREMAIL()

[John_Henry_Jose]

I need to create a Slice based on the USEREMAIL() to verify either he has a right to view particular country data.
This is the table, I need to search.

AND
(
[IsPosted]=TRUE,
IN(USEREMAIL(), SELECT(Tbl_Businessunits[RepresentativeEmailID], [BusinessUnit]=[_THISROW].[xBusinessUnit])))

The above condition does not work as expected.

Any idea please.

Thanks in advance.
John[quote=“John_Henry_Joseph, post:1, topic:34885, full:true”]
I need to create a Slice based on the USEREMAIL() to verify either he has a right to view particular country data.
This is the table, I need to search.

AND
(
[IsPosted]=TRUE,
IN(USEREMAIL(), SELECT(Tbl_Businessunits[RepresentativeEmailID], [BusinessUnit]=[_THISROW].[xBusinessUnit])))

The above condition does not work as expected.

Any idea please.

Thanks in advance.
John
[/quote]

John_Henry_Joseph:

I need to create a Slice based on the USEREMAIL() to verify either he has a right to view particular country data.
This is the table, I need to search.

AND
(
[IsPosted]=TRUE,
IN(USEREMAIL(), SELECT(Tbl_Businessunits[RepresentativeEmailID], [BusinessUnit]=[_THISROW].[xBusinessUnit])))

The above condition does not work as expected.

Any idea please.

Thanks in advance.
John