Count Blanks Table

Hi All,

I would like to make a table in a report which counts whether a store has had 0 sales (blank/lack of data in this case) in a defined period of time.

The main problem I have is the dataset does not contain any information if a product in a store has not sold anything on that day. - Perhaps there is an easy way to populate my sold dataset with blank data if there are no sales?

Therefore I created a measure to check if on a certain day there were sales -> if not then fill that row with 0.

Current Table - need each date in row for measure to work properly

Measure to determine blank data on that day = 0 sales

However, this requires each date/day to be included in the table for the measure to work as intended.

I would like the table to work as pictured; where there is a single line for a store which will count how many 0 sales days it has had and then the deliveries it has had in that time(can do that already). I also don't want to have the date column in the table if possible.

Desired table to look like thisRelationship TableThe sold table - showing when a product in a store sells(no data if no sale on that day)