Clinton, I'm not sure you really need that table calculation. Using Superstore I recreated your situation (see attached).
First it's best if you understand that NULLs are not the same as missing values. When you drag pills out onto the shelves T looks to see if that combination exists in your data. If it does, it shows the results; if it doesn't T blanks the cell -- like this:
ABC, combination exists in your data; blank, it doesn't. So the first thing you'll want to do is fix this by right-clicking the YEAR(date) pill and select 'Show Missing Values'. Your viz will look like this:
From there it's fairly straight-forward. Create a simple COUNTD() calc wrapped in a ZN(). And that should get you this:
Did it work?
Show Missing.twbx 366.9 KB
Unfortunately, it didn't work. I selected the "Show Missing Values", but that doesn't result in all the rows displaying ABC. I was able to reproduce your example with the Superstore dataset though.
What's your data source? A cube?
Update... when I eliminate the filters, it does indeed add zero's.
Data source is a direct connection to MySQL. I'm doing an inner join of two tables.
Update: I've also tested connecting to just one table. And again, when I add a filter, it eliminates the "Missing Value" rows.
We need to use the ZN function to repalce null values with ZERO.
0 ( actual values is null)