Forum Discussion
Not counting all rows
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
1 Reply
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
