My role is blocking my data

[Tatibella]

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.

[ppm1 · Accepted 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

[Tatibella]

Any idea?