How to ignore RLS only

[Anonymous]

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:

Brand	SalesRep	Supervisor	Manager
abc11	a@abc.com	ab@abc.com	abc@abc.com
abc11	b@abc.com	ab@abc.com	abc@abc.com
abc22	C@abc.com	ab@abc.com	abc@abc.com
abc22	d@abc.com	cd@abc.com	abc@abc.com
abc33	e@abc.com	cd@abc.com	abc@abc.com

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)

[negi007 · Accepted solution]

@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