Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

How to ignore RLS only

Hello.

 

I am stuck on a measure that ignores RLS on only one of my measures which calculates share of customers. I did research on this but could not really find something similar to mine. 

 

My tables are something like this:

SalesAuth from Teams:

BrandSalesRepSupervisorManager
abc11[email protected][email protected][email protected]
abc11[email protected][email protected][email protected]
abc22[email protected][email protected][email protected]
abc22[email protected][email protected][email protected]
abc33[email protected][email protected][email protected]

 

 
 
 

RLS is set up like this:

 

The RLS is working just fine except for one of my measures. Which calculates the total shares of a brand on customers. 

We have multiple brands all of them are showing 100% percent because the RLS is blocking the values of other brands. 

the measure is something like this: if I want to  ShareMeasure = (BrandName)/(abc11+abc22+abc33) and it is working fine without any RLS. 

 

What I want to do is just to ignore RLS. While being able to see each customer's subtotals of shares in a table format with this measure. 

 

Please let me know if you have any questions. 

 

P.S. This is the current exact measure:

DIVIDE(
CALCULATE([Total Actual], Answer[Question BrandID] IN {"abc11", "abc22"}),
CALCULATE([Total Actual], ALL(Answer[Question BrandID], Answer[Activity])),
0)

 

Need Help
  • negi007's avatar
    negi007
    5 years ago

    Anonymous In this case you may think of creating a seperate column with no RLS and use this table to calculate share. I am not sure if there is any way you can override RLS in your data. The only way to do is to have a table or column which has no RLS restrictions and use that column or table for calculation in your dax/measure

     

    let me know if this helps you

     

    you can refer to below link for help as well

    https://forum.enterprisedna.co/t/dax-to-ignore-row-level-security/805/6

     

1 Reply

  • negi007's avatar
    negi007
    Community Champion
    5 years ago

    Anonymous In this case you may think of creating a seperate column with no RLS and use this table to calculate share. I am not sure if there is any way you can override RLS in your data. The only way to do is to have a table or column which has no RLS restrictions and use that column or table for calculation in your dax/measure

     

    let me know if this helps you

     

    you can refer to below link for help as well

    https://forum.enterprisedna.co/t/dax-to-ignore-row-level-security/805/6