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
