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?
November 8, 2013
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:
February 9, 2021