Failed to get correct total

[New_be]

Hi expert,
As per subject, I failed to get a correct total headcounts as in the image. To create matrix table visual, I created a measures to calculate the headcount:
          

Headcount =

    CALCULATE(

        MIN('Leavetable'[Headcount]),

        ALLEXCEPT(Calendar, Calendar[YearMonth]),

        ALLEXCEPT(EmpProfile, EmpProfile[Department])

    )
Per department level (department coming from EmpProfile table), I got a correct value, but on the YearMonth level (coming from calendar table) to show the total from the sum of values in department level, I failed. Please show me a correct way to get the total per YearMonth in my case explained in the image attached.

[New_be · Accepted solution]

Hi all,
Thank you for replying, at last I found the solution;
Here is the working measure:

SUMX(

    VALUES(EmployeeProfile[Department]),

    CALCULATE(

        MIN('Leave table'[Headcount])

    )

)

[Uzi2019]

Hi @New_be 

Try below measure:

SUMX(
              SUMMARIZE(‘LeaveTable’,Leavetable[yearmonth],”YM”,leavetabe[Department],MIN(‘Leavetable’[headcount])),
              [HQ]
            )

I hope above measure would work for u!