Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi everyone,
This is the scenario: I have a role for each of the 4 schools according to the ide of the school. Each school should only see its own data, however I have a bar chart where I compare the average grade of a school with the average grade of the 4 schools.
Like this :
78 is the average of one especific school and the 70.6 is the average of the all the four school (by subjet, year, )
However when a user get in the dashboard with an specific school role, he only see the following:
I am using a measure to calculate the average of four schools.
I appreaciate your advice.
Thanks.
Solved! Go to Solution.
Your role is applied in both measures, so you won't see the expected average values. One option is to add a separate summarized table that is not filtered by your role filter that can be used in calculations for all roles.
Pat
Your role is applied in both measures, so you won't see the expected average values. One option is to add a separate summarized table that is not filtered by your role filter that can be used in calculations for all roles.
Pat
Any idea?
User | Count |
---|---|
124 | |
108 | |
99 | |
62 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |