Forum Discussion
Helper VDAX: FILTER issue with scalar values
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
Community Championhow 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
Helper VNo, 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
- MattAllington
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.