I have a report where I'm trying to get the selection to add up and show correctly in the totals. 1. For Period Working Hours, I can get it by individual but the total of the period working hours shows for that time period, but does not account for the # of people in selection for whatever time period selected. So if period working hours = 40 x 4people =160 total period working hours in that time period selected. Note: in my sample, there are a few people (employee B & D) who no matter how many hours there are in the period selected, their period working hours is equal to how many hours they work thus the change in period working hours. I fixed that by using an if statement and a new "PeriodWorkHrs" field in the calendar table.
The total shows 80 (based on the dax of period working hours (how many hrs not including company holidays in this week) which I would like it to show the actual period working hours (PeriodWorkHrs) column total 299 (not 80)
My dax for period working hours may need to change up. I'm not sure what I need to do.