RLS - row level security and OR operator

Hi  po ,

You can apply RLS to the main table (sales table) instead of the RLS table and check like this:

CONTAINS (
    distributor_table,
    distributor_table[distributor_name], "joe bloggs",
    distributor_table[distributor_number], 'sales table'[distributor_number]
)
    || CONTAINS (
        'seller table',
        'seller table'[seller_name], "joe bloggs",
        'seller table'[seller_number], 'sales table'[seller_number]
    )

You could download my pbix file if you need.

Did I answer your question? Mark my post as a solution!

Best Regards

Lucien