Forum Discussion
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.
Thank you in advance for your time on think about this.
Sam
Hi ustas55 ,
Please refer to my .PBIX file.
Best regards,
Lionel ChenIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
7 Replies
Hi ustas55 ,
Like this?
Please refer to my .pbix file.
Best regards,
Lionel ChenIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Lionel,
Thank you.
Sort-of like that. However, when running under Rep-3, I'm getting Sales for Rep-2.
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
Hi ustas55 ,
Has your problem been solved?
Are your three tables like this?
Customer table
Rep table
Sale table
Best regards,
Lionel ChenIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
