Forum Discussion
Missing detail lines in Table Matrix
- Anonymous8 years ago
I have found the issue. I have report level filters. The report level filter is causing the omission of detail lines from the detail visualization table SalesBudget which is attached to the star schema. There is not an omission of data in the Sales Budget Data Summary SUMMARIZECOLUMNS derived table visualization since it is not attached to the star schema even though it summarizes over a table in the star schema.
I would have expected that the result set totals would have been the same. Using the SUMMARIZECOLUMNS could prove to be problematic when there are filters applied and aggregation is needed.
Really tough to say without the data or the PBIX file to mess around with. One possibility is that for some reason in the table visualization it is dropping some rows because of lack of information. If a value is null or blank it tends not to get displayed. Check your FILTERS area. Just really difficult to answer this one.