Forum Discussion

jwin2424's avatar
jwin2424
Resolver I
3 years ago
Solved

Static RLS using IF logic with two tables

Hello community! I cannot find much material out there on DAX expressions for RLS. Here is my dilema. I am trying to create a static security view based on sales territories. However, no territories ...
help needed
  • jwin2424's avatar
    jwin2424
    3 years ago

    Thank you for the quick reply! I tried a few things last night, but I figured out where I was going wrong. I was filtering the role this way:



    I was filtering on two tables, and it was giving me the filter ONLY for the revenue source. 

    I created two roles - one for territory and one for revenue source. Then I gave both roles to the employee and they can see either/or. 

    The formula you provided I believe is for dynamic RLS, and I want to do static RLS. 

jwin2424's avatar
jwin2424
Resolver I
3 years ago

Thank you for the quick reply! I tried a few things last night, but I figured out where I was going wrong. I was filtering the role this way:



I was filtering on two tables, and it was giving me the filter ONLY for the revenue source. 

I created two roles - one for territory and one for revenue source. Then I gave both roles to the employee and they can see either/or. 

The formula you provided I believe is for dynamic RLS, and I want to do static RLS.