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
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: