Forum Discussion

aaverbec's avatar
aaverbec
Regular Visitor
9 years ago

Dynamic Row Level Security on intersection of 2 fields from different tables

I have a requirement for dynamic security that I haven't been able to figure out.  Not sure if it's a tool limitation or just requires more complicated DAX than I understand.   The requirement is t...
Need Help
v-huizhn-msft's avatar
v-huizhn-msft
Microsoft Employee
9 years ago

Hi aaverbec,

If there is a relationship betweem the fact table and dimension table. You should create a relationship between the tables, then use the RELATED function to get the value in fact table. Could you please share your sample data for further analysis?

Best Regards,
Angelia

  • aaverbec's avatar
    aaverbec
    Regular Visitor
    9 years ago
    The two fields we are securing on come from 2 different dimension tables that both relate to the fact table.  Let me know if the pictures below are not sufficient.
    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      I have the same use case. Have you found any solution or workaround?