Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
Solved! Go to Solution.
@jjmartinso Try:
Trigger =
var x = DIVIDE(COUNTA('ScheduleData'[EmployeeID]), COUNTA('Dates'[Date]))
return
IF(x<MAX('DriverDetails'[%DaysWeek]),1,0)
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!
@jjmartinso Sometimes just takes another pair of eyes.
@jjmartinso Try:
Trigger =
var x = DIVIDE(COUNTA('ScheduleData'[EmployeeID]), COUNTA('Dates'[Date]))
return
IF(x<MAX('DriverDetails'[%DaysWeek]),1,0)
User | Count |
---|---|
103 | |
87 | |
77 | |
70 | |
69 |
User | Count |
---|---|
113 | |
99 | |
97 | |
72 | |
68 |