Forum Discussion

abhiram342's avatar
abhiram342
Microsoft Employee
3 years ago
Solved

RLS Dax Query

Hi Team,   I want to implement RLS on Product table and each user can see the sales for multiple products. I have created below DAX code and it's working fine . Want to check if there are other way...
"DAX"
"Need Help"
  • wdx223_Daniel's avatar
    wdx223_Daniel
    3 years ago

    Product[ProductID] IN CALCULTATETABLE(VALUES(ProductRLS[ProductID]),ProductRLS[Alias]=USERPRINCIPALNAME ()&&ProductRLS[IsValidUser]=TRUE())

wdx223_Daniel's avatar
wdx223_Daniel
Community Champion
3 years ago

Product[ProductID] IN CALCULTATETABLE(VALUES(ProductRLS[ProductID]),ProductRLS[Alias]=USERPRINCIPALNAME ()&&ProductRLS[IsValidUser]=TRUE())