Forum Discussion
bhmiller89
Helper V
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 instan...
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
bhmiller89Helper V
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
Community Champion
Community ChampionI 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