Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I want to compare the average FTE from the whole company vs FTE for a specific team, but i ran into a problem when using row level security .
A member of a specific team can only access data for his specific team so i used row level security to implement this.
But this also overrules my ALL function to show the average of the whole company.
Example below:
Correct After row level security
Company wide | Team A | Company wide | Team A | ||
4% | 3% | 3% | 3% |
Is there a solution for this problem?
Solved! Go to Solution.
The only solution to the problem is to create static measures or a separate table where you hold certain, company-wide metrics/aggregations/calculations. This separate table should not be tied to RLS and then you can use the aggregated metrics in that table in your calculations. This way, they cannot see everything except the particular corporate-wide metrics that you make available.
The only solution to the problem is to create static measures or a separate table where you hold certain, company-wide metrics/aggregations/calculations. This separate table should not be tied to RLS and then you can use the aggregated metrics in that table in your calculations. This way, they cannot see everything except the particular corporate-wide metrics that you make available.
User | Count |
---|---|
92 | |
85 | |
77 | |
66 | |
62 |
User | Count |
---|---|
110 | |
95 | |
95 | |
64 | |
59 |