New Member
December 4, 2021
I apologize if this has been asked before but I looked through all of the pages and did not see a topic on it. I have created a Power Pivot in Office 365 from data connected to a SQL server. I created a measure to simply sum the number of rescheduled appointments from the dataset. I then created a Power Pivot table and put my doctors on the rows and the measure in the values. When I double click on the measure result I get all records and not only the records that represent the result of the measure. Is there something that I am doing wrong that I can't get this to drill down correctly?
Power Query
Power Pivot
Xtreme Pivot Tables
Excel for Decision Making
Excel for Finance
Excel Analysis Toolpak
Power BI
Excel
Word
Outlook
Excel Expert
Excel Customer Service
PowerPoint
November 8, 2013
Hi Rob,
drill downs in power pivot measure might not always return results as expected, here is a problem description and a solution that should work for you:
1 Guest(s)