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