Hi Ren, this is pretty easy to solve in Tableau 9. Do you have the option to upgrade?
Ren - Check this out.
V8.2 workbook attached. (Lowest version I could get to.)
I have copy of the data source. And in the copy I made a countd calc.
I use the copy as a secondary source, but I make NO BLEND on it. Because there is no blend, Tableau does the COUNTD without error.
So now you can compare the COUNTD from your primary source with the COUNTD from the secondary (copy) source. If they match, you have ALL.
superstore -- COUNTD.twbx 995.7 KB