Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Dynamic RLS: propagate to non-security dimensions

Hi. I have been struggling finding a good solution to a very common RLS-problem for awhile. I will try to explain it here with a simple example:   My data model contains the following tables:   D...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    The answer was very simple after all... This piece of beauty did the trick:

     

    [CustomerID] =
    CALCULATE (
    MAX ( User[CustomerID] ),
    FILTER ( User, User[UserEmail] = USERPRINCIPALNAME () )
    )

     

    This code needs to be applied to all Dimensions in my security role for which I only want to see lines relevant to Customer XXX

     

    Hope this can help others too. 

Anonymous's avatar
Anonymous
Not applicable
5 years ago

amitchandak 

 

I was unable to find the solution to my problem in the links you provided. I have tried to illustrate the problem here, using another example, that hopefully is easier to relate to (this model works as expected, dynamically filtering Company table to only show allowed companies for UserEmail XXX, but it currently shows ALL Products):

 

 

Any help is much appreciated.

 

sturlaws I see you have solved similar issues in the past, maybe you have a suggestion?

 

I can produce a sample file if needed.

 

/S

  • kumarprabhu815's avatar
    kumarprabhu815
    Frequent Visitor
    3 years ago

    Hey, if you dont mind can you please share the final pbix file with solution