Filtered count

[Anonymous]

I have a datasource with timesheet lines and need a report giving me number total number of workdays for each employee and total for a period.

Columns in the datasource includes Date, EmployeeName, Hours

I have created a custom field WorkedThisDayCalc using IF(Hours>0,1,0) and can summarize in a visual. The works fine except there are occations where there are two records on same date for one employee, giving 2 workdays.

Any way to create a column or measure that filters so that one employee can only have one workday per day?

Hope this makes sense.

[Greg_Deckler]

Mock data please. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490