Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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 |
---|---|
90 | |
74 | |
67 | |
63 | |
55 |
User | Count |
---|---|
102 | |
93 | |
73 | |
60 | |
59 |