Not counting all rows

[JoyfulJess]

Hi

The count total for my dataset is wrong. There are some rows which are not added in the grand total for the total headcount. Please help to see how I can make sure it is counting all rows in the grand total of the total headcount.

I have 3 columns, one is headcount for exec, one for headcount for non-exec and one is the summation of the headcount for exec and non-exec. 

Jessica

[amitchandak]

@JoyfulJess , that may be because you might have ised row context. Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

refer wrong grand total - https://www.youtube.com/watch?v=ufHOOLdi_jk

HR analytics

https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-tr...