I'm trying to create a measure that will give me a count of the # of people who donated last year "T&O-ALL(LY)" but did not donate this year "T&O-ALL." My results kept coming back BLANK, so I created a table with filters to compare.
I've included a screenshot below which shows the problem.
I can't figure out why the "Count of User ID" is BLANK for some rows and "1" for others given the same filter criteria!
The 2nd screenshot shows that if I increase the "T&O-All" filter amount so that there is an actual match, the Count shows up - the I the count when "T&O-All" = 0!
I think if I solve this problem I can create the measure to match it...any insights? Thanks for the help!