The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
We have a business with multiple locations. I have set up RLS to each manager's reports to show only their locations' details. (Sales totals, etc.) Each row transaction has a location column, so the RLS just limits the calculations to those rows that match their location.
Is there a general strategy to allow some summary calculations about other locations through and be seen by each location? Examples would be sales percentages by category, overall margins, A/R collection percentages, etc.... nothing that shows individual amounts or totals, but just averages. (This would give them some helpful context to their own location's report.)
The RLS excludes all of the other locations' data, so measures calculating summaries aren't showing results for anything other than each manager's location. Is there a way to sidestep RLS for specific measures or pass that information through?
Thank you in advance for any help. Mainly just looking to be pointed in the right direction, if possible.
@J_Melton_TX The general strategy is to create a disconnected summary table of the information that is not subject to RLS.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
102 | |
97 | |
80 | |
62 | |
57 |
User | Count |
---|---|
261 | |
120 | |
113 | |
83 | |
71 |