Forum Discussion
Missing detail lines in Table Matrix
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.
Community ChampionReally 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.
Yes this is a tough one!
When I dive into the detail records I am able to find an example where a customer has 6 budget records for the year. One record each for month 2 Feb, 4 Apr, 6 June, 8 Aug, 10 Oct, and 12 Dec. The data appears the same in the data previewer. One of the rows that is being left out of the Table visualization is for month 6 June. The base SalesBudget table is standalone, no relationships. I attempted to post a screen capture of the data records but the tool attached to this board does not allow me to navigate to the saved bmp.
More info - I tested the filter theory by putting the Visualizations on the same page in the report. It did not make any difference, the summary visualization total (CORRECT) was still greater that the detail visualization total (INCORRECT).
I attempted to add a graphic to this post using the Photos tool but it will not accept the BMP that I have.
Thank you for reviewing my original issue.
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.
Anonymous,
If you have solved the issue, you can accept your reply as answer to close this thread.
Regards,
Lydia