dax find number from given week range

matus_jun — Thu, 02 Jan 2025 03:06:59 GMT

Hi im so sorry for my english
how can I know how many people not recive 2 off day, 1 off day or not get any off day base on given range
column workday 1= workday , 0 =offday
thank you alot

Re: dax find number from given week range

shafiz_p — Thu, 02 Jan 2025 05:00:10 GMT

Hi matus_jun Try this:

EmployeesNotReceiving2OffDays = CALCULATE( DISTINCTCOUNT('Table'[employee_id ]), FILTER( ADDCOLUMNS( SUMMARIZE('Table', 'Table'[employee_id ]), "OffDaysCount", CALCULATE( COUNT('Table'[workday]), 'Table'[workday] = 0 ) ), [OffDaysCount] <> 2 ) ) EmployeesNotReceiving1OffDays = CALCULATE( DISTINCTCOUNT('Table'[employee_id ]), FILTER( ADDCOLUMNS( SUMMARIZE('Table', 'Table'[employee_id ]), "OffDaysCount", CALCULATE( COUNT('Table'[workday]), 'Table'[workday] = 0 ) ), [OffDaysCount] <> 1 ) ) EmployeesNotReceivinganyOffDays = CALCULATE( DISTINCTCOUNT('Table'[employee_id ]), FILTER( ADDCOLUMNS( SUMMARIZE('Table', 'Table'[employee_id ]), "OffDaysCount", CALCULATE( COUNT('Table'[workday]), 'Table'[workday] = 0 ) ), [OffDaysCount] = 0 ) )

Hope this helps!!

If this solved your problem, please accept it as a solution and a kudos!!

Best Regards,
Shahariar Hafiz

topic dax find number from given week range in DAX Commands and Tips

dax find number from given week range

Re: dax find number from given week range