Incorrect Number of Rows Returns after Selecting Value in PowerPivot Table

Anything related to PowerPivot and DAX Formuale
Mielkew
Posts: 1
Joined: Thu Oct 17, 2019 1:17 am

Incorrect Number of Rows Returns after Selecting Value in PowerPivot Table

Postby Mielkew » Thu Oct 17, 2019 1:37 am

Hi Guys,
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. File is about 10MB

Please download the file from below link
https://www.dropbox.com/s/zggvhxlhe3u4z ... .xlsx?dl=0

Return to “PowerPivot/DAX”

Who is online

Users browsing this forum: No registered users and 1 guest

cron