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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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

Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

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

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.