I have a list of job numbers and with those job numbers is a list of files uploaded. There can be multiple files uploaded under the same job number. I want to look at just the job numbers and instances of job numbers that have the tag "AGREEMENT."
Initially wrote "IF('dmg vwJMFilesLib'[Tag]= "AGREEMENT", "Yes, "No") but that didn't work because it was not only taking into account the one instance of the job number that did have an agreement.
Per this picture, 2009-PJJ-J01 has two different files uploaded. One is tagged "Agreement" and the other is "Null." I need to write something saying "if 2009-PJJ-J01 (Job) has at least 1 "Agreement" Tag, don't show the the Job Number. I'm only interested in any job lacking an "Agreement" Tagged file.
I may not be understanding what you want, but the formula I gave you works as I expect it to and as I understand the problem. It clearly shows the job numbers that don't have an agreement. Here is a sample