locked
Does cross-table calculation cause the results differ from single table to splitted table with same variants in PowerView? RRS feed

  • Question

  • Does cross-table calculation cause the results differ from single table to splitted table with same variants in PowerView?

    Here's two files based on same data, named "ANSpace20160606(SingleTable)" and "ANSpace20160606" in my case respectively.

    The data in the previous one is all stored in single table, while the data in latter one is stored in several splitted table related by primary and foreign key. 

    The problem is, when the same variants and the same thresholds are applied to both files while charting in PowerView, the results are different. The items filtered in single table is more that in cross-table. 

    When more strict conditions are applied, e.g. field "上市板" selected as fewer items or single item, same results returned .

    Is it caused by the heavy load of cross-table calculation so that only representative results are shown in cross-table file?

    Tuesday, June 14, 2016 1:11 AM

Answers

All replies