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.
Hi,
I'm looking into implementing row level security based on a user's username. I currently have a working solution, but I would like to expand my report, so users can see all data on a high level, but can only see the details for a subset. For example, say the topic is sales, I would want all users to see the high-level sales numbers for each region, but only see the details for stores in their own region.
I'm currently thinking of solving this by making an aggregated table containing the high-level information, but I was wondering if there is an easier way to to this.
Thanks!
Solved! Go to Solution.
Hi Liang,
Thanks for that link, it's very helpful. I wasn't aware that the correct terms for this are visual and non-visual totals, which is why I didn't find any helpful resources online.
Best
User | Count |
---|---|
87 | |
72 | |
68 | |
63 | |
54 |
User | Count |
---|---|
98 | |
89 | |
74 | |
67 | |
62 |