1 of 1 people found this helpful
Hi Shelby! I don't know if you can do this with Sets--at least, not the way you're trying to do it now. Sets group up dimensions, so you'll end up with a kind of drill-down. Let's say that you have some values in and out in each of those 3 categories. You'd actually end up with 8 different rows because it'd be 2x2x2.
What you might want to try instead is to make some conditional counts as calculated fields that count whether each value is missing. Then, you can put those next to each other using Measure Names/Values.
For instance, you might do something like:
IIF(ISNULL([DOB]), 1, 0)
And then sum that up to get the number with a null DOB. And so on.
Calculated fields were all I needed. Appreciate the help!
Great! You're welcome!