PowerPivot cannot drill through like normal PivotTable

[mrchonginhk]

I am using Excel 2016 PowerPivot Pivot table and in page field some items are filtered.

Then I double click some numbers in the table and this warning prompt comes up

"Show Details cannot be executed when multiple items are selected in a ..."

Hey but there is no such irritating error when I use normal PivotTable.

I do not expect PivotTable with "Use Data Model" box checked would run into this message.

What can I do if I really need to filter the table but also need to drill through the items ?
Please help. Thanks

 

[RoryA]

AFAIK, this was supposed to have been fixed in Excel 2016. Which build are you using?

 

[mrchonginhk]

I know why. First I used PowerQuery result to insert PT but checked Data Model box.
Although this enables me to create measure, it does not allow me to drill through.

I actually need to go into PowerPivot table and click add PT and then the PT generated can drill through.
So I suppose this means we must have a Pro version of Excel to have this drill through function ??