Forum Discussion
Solved
count values in a table and include zero when ID doesn't exist
Seems like this ought to be simple and I've found solutions to similar sounding problems but can't make the right connection. I have two tables represented by the simple examples below. The first...
Try adding a +0 to your exisitng COUNTA measure.
It will turn a blank into a 0. Alternatively if you click the down arrow for ID in the visual you can click Show Items with no data (won't get zero's jut blanks):
Thanks to both bcdobbs and dudeyates. Turns out that I had an unrelated date/time issue in my real data (can't share that data here) and that error obscured the benefits of adding+0 to my measure. Now that I've fixed the underlying data issue, adding +0 allows me to include zero values in the result.