Drilling down problems in Power BI

Joca1967

New Member
Joined
Jul 11, 2013
Messages
6
I have a huge data set from different excel sheets. I am building a pivot like salereport where I can filter certain "columns" and I present sale per product and per time periodes. Everything works well until
a want to add another layer

In "Screenshot before" everything is ok you can see that the sale is 42 421 560 in total for EGID 111134 and part T23 you also see above that there is 3 companies that sumerize total sale
in next "screenshot 2 " you only see one company where all sale is presented and this is not right. It should show all three companynames and total sale devided
 

Attachments

  • Screenshot 2.png
    Screenshot 2.png
    219.7 KB · Views: 22
  • Screenshot before.jpg
    Screenshot before.jpg
    151.1 KB · Views: 12

Excel Facts

Test for Multiple Conditions in IF?
Use AND(test, test, test, test) or OR(test, test, test, ...) as the logical_test argument of IF.

Forum statistics

Threads
1,223,214
Messages
6,170,771
Members
452,353
Latest member
strainu

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top