Forum Discussion
Solved
Need help with creating a measure
I have two tables: Absence Detail which lists each planned absence an employee has requested by day (table includes date, employee, department among a few other columns. Department Total which i...
You may use measure below and take advantage of Visual level filters.
Measure = DIVIDE ( COUNTX ( AD, [EmployeeNumber] ), MAX ( DT[total employees] ) )
You may use measure below and take advantage of Visual level filters.
Measure = DIVIDE ( COUNTX ( AD, [EmployeeNumber] ), MAX ( DT[total employees] ) )
Thank you! Now that I see it, it makes perfect sense!