Going to venture a guess here...
Your dimension needs to be the day from your "floating" calendar and then your expression needs to have an if statement to only count a sale where the date of sale = floating calendar date. e.g.
Dimension: [Calendar Date]
Measure: sum(if([Sale Date] = [Calendar Date],[Sale Count]))
Don't know if that helps?
Are you using a Chart to show the data?
If this is the case there is a secondary setting under presentation tab of the properties,
this is "Suppress Zero Values", i have had a similar problem with a relational calender and checking this box allowed all calender dates to be shown in the chart regardless to having no data relating to all dates.
The other option is to realise the join to the calender table as you would in a regular SQL creating one table "FACTS" so to speak but this is dependant on your relation on date, one to one or one to many.
Hope this helps
I made an example, may be it is possible to show the suggested answers there.
@JonathanV: I don't have a floating calendar and I don't think this is a good way for my analysis. The date selection works for a lot of other charts. I just have this problem when I want to show all days of a month with the related sales data.
@Paul Ferguson: I tried several things with these two options under the dimension and the presentation tab. Either I got all dates of all months although I selected just one month or I got just the dates of the selected month with related entries in the sales table.
But could you show me your idea with the join? I would say my relation is many to many. Please look at the example.
MC_Sales_Example.qvw 124.0 K