PDA

View Full Version : In Correct Drill Down Value PowerPivot Table



mielkew
2019-10-16, 04:35 PM
I have a powerpivot table, I don't know why the drill down value is not matching the total number of rows returned.

I don't know whether the DAX formulas require FILTER. Also, I have a separate calendar date I used for slicer only. No relationship is made to my fact table.

I really need to get the exact value as shown in the pivot table.

Any help is greatly appreciated. The file size is about 10MB.

Refer to link: https://www.dropbox.com/s/zggvhxlhe3u4zve/Reporting%20-%20Copy.xlsx?dl=0

Thanks.

Sent from my LYA-L29 using Tapatalk