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?
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:
https://blog.crossjoin.co.uk/2018/12/21/power-bi-drillthrough-complex-measures/
Thanks Catalin for the reply. I forgot to say that I am using Excel 365 and not Power BI. Do you know if there are any workarounds like this for Excel 365?
Thanks again,
Rob
It does not matter, Power BI has the same tools you have in excel: Power Query and Power Pivot
