Hierarchy Not displaying subtotal correctly

Hello,

Here is a copy of the file with the private data removed. 

Thank you so much!
https://drive.google.com/file/d/1YDL4PAs9LLszekYi2rgn2vmJg8VW3v_N/view?usp=sharing

Hi dc52 ,

You can modify your measure like the example below (other measures also modify like the example, you can refer to the attachement of pbix file):

Events Count by Major_ = 
VAR _school = SELECTEDVALUE(Students[School])
RETURN
CALCULATE(
    DISTINCTCOUNT('Events'[ID Name]),
    FILTER('Students','Students'[School]=_school))

And then add a new measure, put the new measure into Matrix:

Events Count by Major =
SUMX(VALUES(Students[School]), [Events Count by Major_])

Final output:

Best Regards,

Ada Wang

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