Error in OLS Implementation for 1 person in 2 separate roles

[datahustle]

I have an employee who belongs to 2 roles for OLS on a Power BI report. The challenge is that this employee, John Doe, belongs to 2 different roles which have conflicting restrictions. See sample below:

After some research, it appears there isn't a way around this using OLS because the 2 roles have conflicting restrictions. For those that are experts in RLS/OLS implementations, any suggestions? The only idea i can come up with is to create a duplicate of the report and apply the RLS/OLS role for Manager 1 to the first and the 2nd report using the Sales Rep 12 role. 

[lbendlin · Accepted solution]

It has always been the case that the more permissive rule overrides the more restrictive rule. "Yes" and "No" in this case results in "Yes". As you correctly state the only way to resolve that is via separate semantic models (not just reports).

[datahustle]

Thanks for confirming and clarifying it's not not the report level but also the semantic layer.