I have NULL values in some rows of a column in my fact table, which contains a foreign key to a dimension table. So some of my rows have no connection to this dimension. I also have some other dimension tables and corresponding columns in my fact table.
When I make a drill-through in my analysis, only the rows without NULL values are shown. The ones with NULL that should be shown in the drill-through are missing.
However, the sum of my sales is shown correctly (the sum of all rows) in the analysis.
I attached the view of my drill-through and the rows I expected to see in it.