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
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?
My opinion on how to solve this has changed since the original post - I would now not recommend the "add zero" approach as it can adversely impact performance and may give unwanted results as in your case.
I would instead recommend:
- Ensure all columns to be used for filter/grouping are in separate dimension tables related to your fact table(s).
In your case this would include User & Application. - Ensure the User & Application columns used on your visuals are those from the dimension tables.
- Once these fields have been added to particular visuals, click the dropdown on the field in the field well and select "Show items with no data"
Regards,
Owen
- Ensure all columns to be used for filter/grouping are in separate dimension tables related to your fact table(s).
That worked perfectly. Thank you!
