The Head Count For 0 Hrs is not possible with a calculated field.
For that you would need to count the distinct names if the sum over the hrs per name equals 0.
As soon as you want to count_distinct a sumOver function QuickSight does not allow the calculation.
I think you have two options:
accept, that your output is the pivot table in the middle of your screenshot (that calculation is possible)
precalculate the sum of Hrs per Name before you load the data into quicksight.
Thank you for your clarification.
I apologize for the delay.
Regarding the count blank in QuickSight, it seems this should be addressed as a provision.
For now, it’s acceptable to perform the calculations before loading data into QuickSight.
However, I have concerns about the direct query; it may not function properly in that case.
You can consider this as something that needs further development.