Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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.
Solved! Go to 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.
@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.
@Anonymous ,
What does "Combined 9 and 10" and "Combined 11 and 12" mean? Could you share more details about the logic?
Regards,
Jimmy Tao
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)
anyone?
User | Count |
---|---|
125 | |
106 | |
99 | |
63 | |
62 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |