DAX Calculation of a column with 1's and 0's

[SRA]

I'm trying to calculate the headcount for a department throughtout the year.  The headcount varies by month so I have a column that has zeros and ones.  When I have tried to sum the column, the amount if off.  How can I get a total sum of tghe headcount for hte year so I can then calculate by month and quarter?

Thank you in advance for any help you can give me with the calculations.

[tackytechtom]

Hi @SRA ,

Please, could you share some example data so it is easier to help you 🙂

/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/

[SRA]

Sorry the data has proprietary information and I'm not able to share it.

[v-easonf-msft]

Hi, @SRA 

You can provide sanitized sample data that fully covers your issue.

It will help to provide the appropriate solution.

Best Regards,
Community Support Team _ Eason