I'm looking to create a measure that can tell me how many contacts that I did not meet with in the 4-8 weeks after I requested a meeting. I'm strugging and can't seem to get the right combination of FILTER functions (of which, I'm a novice).
I have 3 tables: 1) Meeting Requests, 2) Meetings and 3) Contacts:
The desired outcome in the above scenario is 1 (red). I reached out on 2/1/2018 and didn't meet in the next 4-8weeks.
Ultimately I'd like to be able to slice this measure in visuals by year. Potentially other slices as well.