DAX calculate table values that is not blank

I have the following hierarchy table and am stuck to generate a sub table that can filter out the blank row. Any assistance would be most appreciated! Department Manager Staff Human...