Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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.
Solved! Go to Solution.
I posted this earlier, but some issue with forum. Anyway, it works for me. https://dl.dropboxusercontent.com/u/30711565/missing%20agreement.pbix
Unless I misunderstand
how about this.
Jobs missing agreements = if(calculate(countrows(vwJMFilesLib),vwJMFilesLib[Tag]="Agreement")=0,1)
Put this measure in a table or matrix, and the job number on rows
No, didn't work.
Basically need to find a way to say "If Job Number has more than one occurence, exclude all occurences except where the "Tag" column = "Agreement."
That way I can get a list of Job NUmbers that don't have agreement file types. Most Job Numbers have multiple file associations, but I need to single out jobs that do not have "Agreements" at all.
I posted this earlier, but some issue with forum. Anyway, it works for me. https://dl.dropboxusercontent.com/u/30711565/missing%20agreement.pbix
Unless I misunderstand
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
https://dl.dropboxusercontent.com/u/30711565/missing%20agreement.pbix
If it is not what you are after because I don't correctly understand, then that is a different issue of course.
User | Count |
---|---|
139 | |
113 | |
103 | |
73 | |
63 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |