Nested Drillthrough giving Summarized values at second drill report

[sanjaysingh]

Hi,

I have created  3 reports Branch wise  Sales Qty and Amount,  Customer Group Wise   Sales Qty and Amount and then ,  customer wise Sales Qty and Amount

I am drilling down from Branch level to Customer Group   and then to Customer report.

at the customer level report when i drill against a particular group qty and Amount is same for all customer which is the summarized value of that Customer group.

Customer GroupCustomer Wise del_Qty & Del_Amt is same.

[v-chuncz-msft]

@sanjaysingh 

You may set cross filter direction between 'Budget_data' and 'BP_Master' to 'Both' in the Edit relationship dialog.

[sanjaysingh]

After doing That , now bud_Qty and Bud_Amt started facing problem,

now rest of the column except del_Qty and Del_Amt are showing same values.

All the coulmns which are coming from Budget data table are showing same values.

I am attaching the revised pbix file on one drive below is the link.

https://merinoservices-my.sharepoint.com/:u:/p/sanjaysingh/EUEjbOd2bh5KjoUCbU5teTABAU7dpZM9b5mO4oRij...

[sanjaysingh]

Hi,

Please find the Pbix file placed in one drive.

Below is the link.

https://merinoservices-my.sharepoint.com/:u:/p/sanjaysingh/EZjzcwGuYsJElxWAq2Qxz_wBMSGOSH5c1aQv5IFTc...