Forum Discussion
Include Zero on a Table
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
The simplest way I know of is to add +0 to the end of your measure.
This will convert blanks to zero and leave nonblanks unchanged.
I'm not using a measure, though. It's a table where "Name" is a text value and "Count" is a count of the data.
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 came across your solution to someone with a similar problem, but when I tried it, the results included all rows, even those that had been filtered out previously by a parameter...
I have a table with users & applications that they have purchased; a second table with usage of applications by all users. I have a drop-down filter to select which application to view data on - which should show the users who have the application and the count of hits in the usage table.
When I use the built in count drop-down in the table field settings, only rows of users with usage appears. I created a measure as you recommended to include users with no usage, but the table then stopped responding to the application name filter - regardless of which value I select, all applications are now displayed in the table.
Can you help me get the count, including rows with no usage, for only the applications that have been selected in the filter?
