If a measure is less than a table value then 1 else 0

[jjmartinso]

I have created a measure to calc the % of days an employee is on the schedule based on the selected dates.  I want to compare that to how many days the employee should appear on the schedule based on employee's defined schedule.  In trying to create a filter for my table, I am trying to produce a 1 or a 0 based on var x and the table value. 

The table is structured like the below with a date slicer linked to the table:

Region

Site

Name

EmployeeID

% of Days on Schedule

The % of Days on Schedule uses the var x calculation, shown below.

Trigger =

var x = DIVIDE(COUNTA('ScheduleData'[EmployeeID]), COUNTA('Dates'[Date]))

return

IF(x<'DriverDetails'[%DaysWeek],1,0)

The above is returning this error:
A single value for column '%DaysWeek' in table 'DriverDetails' cannot be determined. This can happen when a measure formula refers to a column that contains many values without specifying an aggregation such as min, max, count, or sum to get a single result.

I have searched for a solution and tried various modifications to get this to work but have been unsuccessful.  Any thoughts on the direction I should take?

[jjmartinso]

Doh, I think I will commence banging my head against my desk.  I can't believe I spent a while on that one.  
Appreciate your help!

[Greg_Deckler]

@jjmartinso Sometimes just takes another pair of eyes.

[Greg_Deckler · Accepted solution]

@jjmartinso Try:

Trigger =
var x = DIVIDE(COUNTA('ScheduleData'[EmployeeID]), COUNTA('Dates'[Date]))
return
IF(x<MAX('DriverDetails'[%DaysWeek]),1,0)