Need help on applying RLS

Heena_9980400 — Sun, 29 Jan 2023 14:23:38 GMT

Hi Experts,

I have attached a screenhsot below where i need to apply RLS,where if a cx selects company code-01, he should see all countries from company code 1, like same wise for all company code i need to implement same.

Please could you help me out on this.

Thanks in advance,

Regards,

Re: Need help on applying RLS

amitchandak — Mon, 30 Jan 2023 04:20:21 GMT

Heena_9980400 , Assume you have company dimension joined with your fact or fact has company code

Create a Table with the company Code, segment, and email, and that should have all the details. Join it with dimension and fact and create RLS on this new table

How to use Row Level Security (RLS): https://youtu.be/NfdIA0uS6Nk

https://community.powerbi.com/t5/MBAS-Gallery/Microsoft-Power-BI-Unleash-row-level-security-patterns-in-Power/td-p/712613
https://radacad.com/dynamic-row-level-security-with-organizational-hierarchy-power-bi

topic Re: Need help on applying RLS in DAX Commands and Tips

Need help on applying RLS

Re: Need help on applying RLS