Skip to main content
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Regular Visitor

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

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.

Super User
Super User

Hi @SRA ,


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



Did I answer your question➡️ Please, mark my post as a solution ✔️

Also happily accepting Kudos 🙂

Feel free to connect with me on LinkedIn! linkedIn


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

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

Helpful resources


Fabric certifications survey

Certification feedback opportunity for the community.


Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.