Thanks for the ping, @Diego!
It's a bug in Tableau v9.0 that changed Tableau's densification behaviors (of which Show Missing Values is one), I know it's fixed as of Tableau v9.2.6. If you upgrade it'll be fixed. If you can't upgrade then you can put an INDEX() table calculation onto the Level of Detail Shelf and set the Compute Using to Table (Down). This triggers domain completion densification and gets similar results, I've attached a v9.0 workbook with INDEX() added as an ad hoc calculation.
A way to more fully avoid this problem is to use a third data source that has all of the dimensionality you need, i.e. every combination of date and Nom du type d'enregistrement (groupe), you would use that source as the primary source and then blend in both the Contracts and Ended contracts sources.
Hi Jonathan Drummey,
Thank you for your answer. And sorry I didn't responded before.
I took some time this morning to test the different ways you gave me.
First, I updated Tableau Desktop to v.9.3, and I'm still missing some ended contracts because of the inner join on "date de début" from my primary data source. No data on the primary data source => no date on the secondary data source.
I tested the solution with a third data source, but the problem remain the same as I used the field "date de début" as a column so the inner join doesn't work.
I attached another sample dashboard with two sheets.
The first sheets show the number of customer without densification.
The second one is the same by sector & activity.
The total is not the same, because I'm missing ended contracts in the second sheet ...
Contracts.twbx 7.9 MB