In Correct Drill Down Value PowerPivot Table

mielkew

New member
Joined
Feb 18, 2018
Messages
6
Reaction score
0
Points
0
Excel Version(s)
2016
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 - Copy.xlsx?dl=0

Thanks.

Sent from my LYA-L29 using Tapatalk
 
Last edited:
Top