cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

Compound RLS

Good Day Professionals,

I'm relatively new to Power BI, so please excuse my basic (if that) question.

Looking for advice on how to achieve/implement dual RLS mode.

In my simple example, let's say there're 3 Customers, and every Customer has a dedicated (current) Sales Rep. Those customers made a sale. However, when transaction was made, it was associated with other Sales Reps. 

I've created a simple star schema model and need to create 2 reports: first to dispalay sales informattion based on the current Rep associated with the Customer, other report should display sales based on the Rep who made a transaction. 

Esentially, Rep 2 from Customer should see $200, while Rep 2 on Transaction should see $500.

 

RLS.jpg

Thank you in advance for your time on think about this.

Sam

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Support
Community Support

Re: Compound RLS

Hi @ustas55 ,

 

Please refer to my .PBIX file.

aaa7.PNGaaa8.PNGaaa9.PNG

 

Best regards,
Lionel Chen

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

 

View solution in original post

7 REPLIES 7
Highlighted
Highlighted
Community Support
Community Support

Re: Compound RLS

Hi @ustas55 ,

 

Like this?

aa12.PNG

Please refer to my .pbix file.

.pbix file 

 

Best regards,
Lionel Chen

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

Highlighted
Frequent Visitor

Re: Compound RLS

Hi Lionel,

 

Thank you.

Sort-of like that. However, when running under Rep-3, I'm getting Sales for Rep-2.

 

RLS-1.jpg

My dilemma, I guess, is that security has to be “dual” and independent mode. First, (Master data report) has to filter Reps on the Customer table (like in your sample model). Second (transactional),  has to be on the Rep table.

 

Best Regards,

Sam

Highlighted
Community Support
Community Support

Re: Compound RLS

Hi @ustas55 ,

 

Has your problem been solved? 

Are your three tables like this?

 

Customer table

gg8.PNG

Rep table

gg9.PNG

Sale table

gg10.PNG

 

Best regards,
Lionel Chen

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

Highlighted
Frequent Visitor

Re: Compound RLS

Hi Lionel,
Unfortunately no, still pursuing opportunities on how to make it work.

My tables are as follow:

RLS-2.jpg

 

Just want to reiterate what I’m trying to achieve…. This RLS should accommodate reps who are currently assigned to a customer and reps that made transaction; “master data” vs “transactional”.

Rep-1 has 1 customer and 1 transaction. $100 should be returened using both RSL methods.

Rep-2 has 1 customer and 2 transactions. So if Rep-2 needs to see “master data”, he should see only $200. If he wants to see transactional, he would see $500.

Rep-3 has 1 customer and no transactions. So he should only see $300 associated with customer “C”. Since Rep-3 didn’t have any transactions, his “transactional” report should not display any numbers.

 

Thank you for looking into it.

Best Regards,

Sam

Highlighted
Community Support
Community Support

Re: Compound RLS

Hi @ustas55 ,

 

Please refer to my .PBIX file.

aaa7.PNGaaa8.PNGaaa9.PNG

 

Best regards,
Lionel Chen

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

 

View solution in original post

Highlighted
Frequent Visitor

Re: Compound RLS

Thank you Lionel, 

I think it will work. At least I've got a concept.

 

Best Regards,

Sam

Helpful resources

Announcements
Super Users of the Quarter - Q2 2020

Super Users of the Quarter - Q2 2020

Who are our Super User Superstars? Who made it to the top of the leaderboards? Get the answers!

Community Summit Australia – Join Online!

Community Summit Australia – Join Online!

Be a part of the leading Microsoft Business Applications digital event, curated for the APAC community.

Top Solution Authors