Forum Discussion
Display zero instead of blank in matrix table
I have a situation where users enter data on a form and one of the values they selectare dependent on an asset area and a date. When displaying this information in a matrix table I want to display a ...
I had a similar problem where the fact table had an incomplete list of dates, (ie from the data, there was no entry for 1/1/2019). When you summarise in a table, matrix or line graph, the data point for 1/1/2019 doesn't show up, or has no entry (not even blank).
To solve the issue, you need two things:
1. Either of the already suggested solutions (+0, ISBLANK logic) AND
2. Create a Calendar table that has every date listed, create a relationship between this table and your fact table, then use the Calendar table to drive the visualisations.
Now when DAX evaluates the measure, it specifically looks at every date, and can evaluate to 0, intead of only looking at the dates with information in the fact table.