DAX Measure that ignores Row level security

[ryan_b_fiting]

Hello Community - 

I am looking for some assistance and guidance on understanding if there is a way to 'ignore' Row Level Security roles on one specific measure? 

I have several healthcare providers who see patients regularly, but the patient does not always book future appointments with the same provider.  We have the RLS set up at the provider level so when they log in, they can only see the data associated with their UPN.  However, I want to create one measure that will skip over that RLS role so that the provider can see the number of future appointments for a patient they have seen in the past, even if the futurue appointments are not booked with the provider that is viewing their report.

Is this possible, or is this just a dream for my client and I to resolve?

Thanks in Advance Community!

Ryan Fiting

[amitchandak]

@ryan_b_fiting , if you have used RLS< you can not ignore for a measure. We usually create Table(Fact) where RLS do apply and create a measure from that

[DavidMG82]

Any other post related to this to use as an example?