Table1 = USERPRINCIPALNAME() OR Table2 = USERPRINCIPALNAME()

CHRBAR — Sun, 21 Jan 2024 08:35:19 GMT

I'm new to DAX and Power BI

I have a problem with RLS.

I have a bunch of tables based on Business Central and Excel files. All are linked to the main table "Trades" including the 2 tables : "Seller" and "Purchaser"

I have then set up RLS to the Seller table with : [E_Mail] = USERPRINCIPALNAME()

All good so far

Small example of the "Trades" table

Trade No	Amount	Seller	Purchaser
1	500	JOE	JOE
2	200	SAM	SAM
3	522	JOE	SAM
4	632	KATE	SAM
5	5612	JOE	JOE
6	6523	KATE	KATE
7	522	KATE	SAM

Problem is now that SAM only has access to the details in no. 2, where he's the Seller

I am looking for a way to give access to all the deals that the employees are involved in.
So SAM should see lines 2, 3, 4, 7

Any ideas?

Re: Table1 = USERPRINCIPALNAME() OR Table2 = USERPRINCIPALNAME()

Fowmy — Sun, 21 Jan 2024 10:07:51 GMT

CHRBAR

You can setup a RLS rule using a measure as follows, my table is Table33.

Measure: NOTE: "SAM" to USERPRINCIPALNAME()

VAR __User = "SAM" VAR __Result = __User IN ({Table33[Seller], Table33[Purchaser]}) RETURN __Result

My testing:

topic Table1 = USERPRINCIPALNAME() OR Table2 = USERPRINCIPALNAME() in DAX Commands and Tips

Table1 = USERPRINCIPALNAME() OR Table2 = USERPRINCIPALNAME()

Re: Table1 = USERPRINCIPALNAME() OR Table2 = USERPRINCIPALNAME()