Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Find the name with no entry

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...
Need Help
Show and Tell
Tips and Tricks
MFelix's avatar
MFelix
Icon for Super User rankSuper User
2 years ago

Hi Anonymous ,

 

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