Forum Discussion

Scott_Visio's avatar
Scott_Visio
Frequent Visitor
4 years ago
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...
Need Help
  • bcdobbs's avatar
    bcdobbs
    4 years ago

    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):

     

Scott_Visio's avatar
Scott_Visio
Frequent Visitor
4 years ago

I've tried +0 and there's no change but that could be the result of other formula elements in the real measure. The visual I'm using doesn't include a show items with no data.

 

Let me go back to the real data and see whether I can figure out something else.

dudeyates's avatar
dudeyates
Frequent Visitor
4 years ago

Hello Scott_Visio 

 

I agree with bcdobbs. It also might be you're pulling the department table ID instead of the ID from the ID table into the visual? I'd made that mistake when duplicating your data 🙂


Once I pulled the right ID column I got the correct results 

 

 

Hope that helps!
James