Forum Discussion

CHRBAR's avatar
CHRBAR
New Member
2 years ago
Solved

Table1 = USERPRINCIPALNAME() OR Table2 = USERPRINCIPALNAME()

Hi

 

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 NoAmountSellerPurchaser

1

500JOEJOE
2200

SAM

SAM
3522JOESAM
4632KATESAM
55612JOEJOE
66523KATEKATE
7522KATESAM

 

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?

  • Fowmy's avatar
    Fowmy
    2 years ago

    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:

     

     



     

1 Reply

  • Fowmy's avatar
    Fowmy
    Super User
    2 years ago

    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: