Forum Discussion

ryan_b_fiting's avatar
ryan_b_fiting
Post Patron
3 years ago

DAX Measure that ignores Row level security

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

Need Help
Show and Tell
Tips and Tricks
Tutorial Requests

2 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    3 years ago

    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

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

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