Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi everyone, :))
I would like to give you an example of what I would like to achieve as it is hard to explain :).
Due to RLS Student "A" could only see his average scores, whilst I would like him to see the average for both A and B. in this sense, how can I let a measure bypass/skip RLS
Student NameGradeTerm
A | 23 | 1 |
A | 32 | 2 |
A | 21 | 3 |
A | 22 | 3 |
B | 20 | 3 |
B | 19 | 3 |
B | 19 | 2 |
B | 21 | 2 |
B | 29 | 2 |
your help is much appreciated,
Amr
Hi @Anonymous
What if you create a new table (Table2) with a single column and row which just stores the average for both A & B?
You can then set your RLS as per usual on your first table but then you do not need to set any RLS on Table2 and you can display that average however you want.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
100 | |
80 | |
63 | |
58 |
User | Count |
---|---|
148 | |
111 | |
94 | |
84 | |
67 |