Name list of absent

[rajasekar_o]

id	name
101	RAJA
102	RAM
103	KUMAR
104	JOHN
105	JOTHI
106	VIMALA

login data

ID	DATE	IN OUT
101	20-03-2023	IN
101	21-03-2023	IN
102	20-03-2023	IN
102	20-03-2023
103	21-03-2023	IN

i need help,
i want name list of absent,
if the employee dont have "IN" in ( login data in out column)  then emloyee absent 
i tryd but not get correct answer 
empmaster data

[v-nuoc-msft]

Hi @rajasekar_o 

If my answer is correct, please mark it as accept as solution.

Regards,

Nono Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[v-nuoc-msft · Accepted solution]

Hi @rajasekar_o

@amitchandak Good share!

I have provided other ways to solve this problem, please try the following operations:

Here's some dummy data

"login data"

"Table"

Create a measure. Determine whether there is an absence in the record:

IN_OUT = 
    IF(
        SELECTEDVALUE('login data'[IN OUT]) <> "IN", 
        1, 
        0
    )

Create a measure. Find the list of absentees:

Name = 
var _id = 
    CALCULATE(
        SUM('Table'[id]), 
        FILTER(
            ALL('login data'), 
            [IN_OUT] = 1
        )
    )
RETURN 
    CALCULATE(
        MAX('Table'[name]), 
        FILTER(
            'Table',
        'Table'[id] = _id
        )
    )

Here is the result:

If you're still having problems, provide some dummy data and the desired outcome. It is best presented in the form of a table.

Regards,

Nono Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@rajasekar_o , Please find the attached file after signature,