Displaying Matrix visual values in multiple columns

[Anonymous]

I have student data for 10 schools. I am trying to calculate and display in a matrix visual the student strength by level of education they are in.

I have data as below:

School Name        Class            Strength

AAA                      Grade 9            20

AAA                      Grade 10          35

AAA                      Grade 11          12

AAA                      Grade 12           5

BBB                       Grade 9            20

BBB                       Grade 10          55

BBB                       Grade 11          25

BBB                       Grade 12          14

CCC                       Grade 9            20

CCC                      Grade 10           45

CCC                      Grade 11           15

CCC                       Grade 12          14

I want to see the display the data in the matrix as follows

School Name      FS (Combined 9 and 10)       JS (Combined 11 and 12)

AAA

BBB

CCC

I know this might be too easy. But rookie here. Thanks.

[v-yuta-msft · Accepted solution]

@Anonymous ,

Firstly, create an additional column "Category" using DAX below:

Category = IF('Table'[Class] = "Grade 9" || 'Table'[Class] = "Grade 10", "FS", "JS")

 

Then create a matrix visual, drag Category to Columns, School Name to Rows and Strength to Values.

 

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[v-yuta-msft]

@Anonymous ,

What does "Combined 9 and 10" and "Combined 11 and 12" mean? Could you share more details about the logic?

Regards,

Jimmy Tao

[Anonymous]

@v-yuta-msft 

Combined means to add the strength of both classes. So basically, in our system, we have two categories

Category A (Grade 9 and 10)

Category B (Grade 11 and 12)

[Anonymous]

anyone?