Forum Discussion
Helper VDAX: FILTER issue with scalar values
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 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
4 Replies
- MattAllington
Community Champion
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
- bhmiller89
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.
- MattAllington
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
