Calculating Weeks With Hours Worked

[nbarta]

Hello - I need to calculate the number of weeks Employees have worked either regular or overtime hours. I have two tables - The first I'll call EmployeeData with distinct employee IDs and other relative data, and another I'll call EmployeeHours which is a table that records the daily number of hours containing Employee IDs, Full Date, Week Of Year, Regular Hours, Overtimehours. I need to put the total number of weeks worked into the table with distinct employee IDs. I cannot just count distinct WeekOfYear because sometimes the values of hours worked is 0. 

I'm trying to do a calculated column in the EmployeeData table but it's not working: 

EmpWeeksWorkedCalc =
CALCULATE(
    DISTINCTCOUNT('EmployeeHours'[WeekOfYear]),
      SUM('EmployeeHours'[OTHours]) > 0) || 
      SUM('EmployeeHours'[RegularHours>0)) 

Thanks for any help! 

[Anonymous]

Hi, @nbarta 

May I ask if your problem is solved? If not resolved, can you provide sample data and your expected output? This will better describe your problem. How to provide sample data in the Power BI Forum - Microsoft Fabric Community

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[lbendlin]

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information. Do not include anything that is unrelated to the issue or question.
Please show the expected outcome based on the sample data you provided.

Need help uploading data? https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...