measures in a table/matrix

[Anonymous]

Hi,

I am a student currently doing a work placement. I have been tasked with creating a visual based on the clients needs they would like this to be in the form of a matrix. I have been able to create the measures required to achieve this but am currently struggling with being able to visualise it the way they have asked.

Field List:

Calculated columns :

Measures:

Here is an example of a chart I already have which shows the average score for each subject across all schools.

Below are the tables I have for my dataset:

Below is an example of how they would like the outcome to be presented which I am struggling with:

[v-yingjl]

Hi @Anonymous ,

Based on your description and sample data, not certain what is your expected output.

In your datasets, there are only 4 students from school A, what about others? Have you created relationships between these tables? 

Could you please consider sharing more details about this issue or a sample file for further discussion?

In addtion, if you want to use a matrix to show the result which is simliar with the last picture, I'm afraid you could not achieve this because measrue can not be used as rows / columns in matrix.

Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[HotChilli]

Have you set up the table relationships?

The visual you want is a matrix.  What have you got so far?