Exclude rows with blank values from non-exisiting combinations in data

Hello,

I am developing a Power BI report, where two tables are used; A Fact table (FactTable) and a Date table (DatumTabel). Between the tables an active one-to-many relationship exists between the key fields DatumTabel [Date] en FactTable[1e Wijzigingsdatum].

The FactTable consists of a couple of columns that are used:

Multiple Alert Reasons can exist within a single Ordernumber. The same alert reason can also exist within multiple Products.

For each date from the Date table, I would like to count the number of Orders per Product and Alert Reason combination. If there are no Orders available in the FactTable for a specific combination, I would like to see ‘0’. This can be achieved with a simple measure: OrderCount =  COALESCE(COUNT(Ordernumber),0).

In the report I created a table visual that consists of the columns of the FactTable and the Date column from the Date table. It looks like the following;

This OrderCount measure works when the combination of FactTable[Product] en FactTable[Alert reason] exists in the fact table, but for combinations that do not exist in the data, a blank value is returned in the table visual (see the rows in red).

I would like to see for every possible date the existing value combinations of Product and Alert Reason (see green row). 

I would like to exclude these non-existing combinations (red rows) from the visual. I have tried several options. For example exclude blank values of OrderCount in the filter pane, use COUNTROWS > 0 in the OrderCount measure, but none of them work. The DAX CROSSJOIN function is not an option because of the amount of data.

How can we exclude these non-exisiting combinations from the table visual?

I hope someone can help me out. Thanks in advance!

Kind regards,

Jerry