dax find number from given week range

[matus_jun]

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

[shafiz_p · Accepted solution]

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