RLS based on 3 conditions from multiple columns

[jlegutko_abb]

Hi All,

I have a separate table called RLS-Accessdetails with person email, program, country/region and it looks as below:

I must create complex RLS which for example for Test User will show:

- only results from Poland for courses with PET tag,

- only results from Poland for courses with EL_Digital tag,

- results from all countries and regions for courses with PMDI tag,

- results from all countries and regions for courses with SCDI tag

I don't know how to make it possible if I have a few rows for each user email and rules are different for each tag.

Relationships between tables:

* TAGS and RLS-Access-Details (the sheet above)

* CountrytoRegion (which is realted to main table with enrollments) to RLS-Access-Details

Any suggestions how to make it work?

[Icey]

Hi @jlegutko_abb ,

---

I must create complex RLS which for example for Test User will show:

- only results from Poland for courses with PET tag,

- only results from Poland for courses with EL_Digital tag,

- results from all countries and regions for courses with PMDI tag,

- results from all countries and regions for courses with SCDI tag

I don't know how to make it possible if I have a few rows for each user email and rules are different for each tag.

---

Is there any pattern? Can they be grouped?

In addition, could you create some sample data just for the three tables, "RLS-Accessdetails", "TAGS", "CountrytoRegion"? 

No need for real data, just need to know what your data structure is like.

Reference: How to provide sample data in the Power BI Forum - Microsoft Power BI Community

Best Regards,

Icey

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[parry2k]

@jlegutko_abb I will start with writing a DAX measure that will return TRUE when different conditions are met and that will be first starting point.

✨ Follow us on LinkedIn

Check my latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡

[parry2k]

@jlegutko_abb can you share a sample pbix file and I will put the solution together, it is hard to explain without looking at the pbix. Remove sensitive information before sharing the file.

[jlegutko_abb]

hi @parry2k , thank you for the response. Unfortunately I can't share any pbix file. Maybe you can describe overall the concept? Or functions you would use to create that type of rls? Any hints for me?