无法深入查看具有正确结果数量的详细信息 [英] Unable to drill down to details with the correct number of results

问题描述

从powerpivot生成的数据透视表显示10的结果但是当深入到详细信息时我得到100行。

The pivot-table generated from powerpivot which shows results of 10 but when drill down to details i get 100 lines.

有没有办法显示正确的数字与结果对应的行？

Is there a way to show the correct number of lines in correspondence with the result?

推荐答案

这表明值10是某种计算度量的结果，该度量在100行原始数据之上应用一些额外的过滤。 drillthough只能显示最初输入计算的记录，其中
将是行/列加上任何过滤器的上下文。 drillthough不会尝试解析任何其他逻辑或过滤度量表达式。

This suggests that the value of 10 is the result of some sort of calculated measure that is applying some additional filtering on top of the 100 rows of raw data. The drillthough can only show records that were originally fed into the calculation which will be the context from the rows/columns plus any filters. The drillthough will not attempt to parse into any additional logic or filtering inside your measure expression.

这篇关于无法深入查看具有正确结果数量的详细信息的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！