Find the name with no entry

[sonalisaha2310]

Hello, I need a help in getting the name who has not made the entry , below given is the example

I have few tables 

Table 1 - It contains all the weeks 

Week

01/01/2024 - 01/07/2024

01/08/2024 - 01/15/2024

01/16/2024 - 01/22/2024

01/23/2024 - 01/31/2024

Table2-It contains all the name and email

Name	email
A	A@gmail.com
B	B@gmail.com
C	C@gmail.com
D	D@gmail.com

Table3 - It contains the name and the entries entered in weeks

Week	name	email	total
01/01/2024 - 01/07/2024	A	A@gmail.com	31
01/01/2024 - 01/07/2024	B	B@gmail.com	34
01/01/2024 - 01/07/2024	C	C@gmail.com	67
01/08/2024 - 01/15/2024	A	A@gmail.com	43
01/08/2024 - 01/15/2024	B	B@gmail.com	23
01/08/2024 - 01/15/2024	C	C@gmail.com	12
01/08/2024 - 01/15/2024	D	D@gmail.com	98
01/16/2024 - 01/22/2024	A	A@gmail.com	12
01/16/2024 - 01/22/2024	B	B@gmail.com	54
01/16/2024 - 01/22/2024	D	D@gmail.com	45

I want to have a table with the name who has not marked hours as per the week , for example

D has not marked the hour for 01/01/2024 - 01/07/2024,01/23/2024 - 01/31/2024 week , similarly for other names as well

Week	name	Email
01/01/2024 - 01/07/2024	D	D@gmail.com
01/16/2024 - 01/22/2024	C	C@gmail.com
01/23/2024 - 01/31/2024	A	A@gmail.com
01/23/2024 - 01/31/2024	B	B@gmail.com
01/23/2024 - 01/31/2024	C	C@gmail.com
01/23/2024 - 01/31/2024	D	D@gmail.com

[sonalisaha2310]

Hello, thank you for the reply , could you please send the pbix file?

[MFelix · Accepted solution]

Hi @sonalisaha2310 ,

Please see PBIX file attach.

[MFelix]

Hi @sonalisaha2310 ,

You can create the following measure:

Validation = IF(SELECTEDVALUE(Names[email]) in VALUES('Fact'[email]), BLANK(),1)

Now you have two options:

• Add this value to you table and the result will be a table like this

You can decrease the size of the column or format the text to be white or a icon.

• Add the measure has a filter
• Select is not blank
• Right click the fields and Show items with no data