locked
Unable to drill down to details with the correct number of results RRS feed

  • Question

  • 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?


    Thursday, March 7, 2019 6:37 AM

Answers

  • 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.

    http://darren.gosbell.com - please mark correct answers

    Friday, March 8, 2019 1:47 AM

All replies

  • 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.

    http://darren.gosbell.com - please mark correct answers

    Friday, March 8, 2019 1:47 AM
  • How is it possible that i can get the results of the filtered value to drillthrough.
    Monday, March 11, 2019 7:08 AM