Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time 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:
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:
Solved! Go to 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
Proud to be a Super User!
@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
Proud to be a Super User!
User | Count |
---|---|
141 | |
113 | |
104 | |
78 | |
64 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |