Distincount with multiple condition

Hi Wajdi,

I'm confused about your description, can you please share some more about the detailed description of these conditions?

How to Get Your Question Answered Quickly 

In addition, you can also try to use the following calculated column formula to check and remark the device status based on the date and device name:

Status = 
VAR workRange =
    CALCULATETABLE (
        SUMMARIZE ( 'Table', [Date], [Device], [Work Style] ),
        FILTER (
            'Table',
            [Time] >= TIME ( 8, 0, 0 )
                && [Time] <= TIME ( 20, 0, 0 )
                && [Work Style] <> 0
                && [Device] = EARLIER ( 'Table'[Device] )
                && [Date] = EARLIER ( 'Table'[Date] )
        )
    )
RETURN
    SWITCH (
        COUNTROWS ( workRange ),
        3, "Hybrid",
        2,
            IF (
                COUNTROWS ( FILTER ( workRange, [Work Style] = 5 ) ) = 0,
                "Remote",
                "Hybrid"
            ),
        1,
            IF (
                COUNTROWS ( FILTER ( workRange, [Work Style] IN { 10, 15 } ) ) = 0,
                "Office",
                "Remote"
            ),
        "Offline"
    )

Regards,

Xiaoxin Sheng