Forum Discussion
Solved
Include Zero on a Table
I'm making a table visual with two columns, Name and Count. This works perfectly well at counting data, but I also want to include "Names" for which there is no data (thus the Count would be 0). How ...
Oh right, so you're using the 'Count' aggregation from the dropdown on the field.
I think you'll need to define your own measure instead to stop the blank row removal.
e.g.
Count Measure = COUNT( Table[Column] ) + 0
I will assume that the data table in which you are working - if a name has no data/record then it does not appear in this table. Let's call this Table1
So you need a data table that has all names - possible you need to create that, which is a straight forward task using the New Table feature. In any case call that Name Table.
Have a join line between these 2 data tables
Then in your Visual table use Name table, and a Measure =Count(Related(Table1))
Just air code but that's the idea I think will work.