Tree Hierarchy drill down issue

Anything related to PowerPivot and DAX Formuale
Posts: 1
Joined: Wed Jun 24, 2020 11:12 pm

Tree Hierarchy drill down issue

Postby jajecko » Wed Jun 24, 2020 11:45 pm

Let's say I have 3 tables as below:


each product in Products tab has the "catID"

In Categories tab I have categories with given catID, catName and parentCategoryID.

I have created a parent-child hierarchy using pattern which can be found here:

And everything works perfect, but the problem is that I have only sales by Categories. What I'd like to achieve is to have the possibility to drill down to check the sales of particular products in given category. Unfortunately it doesn't work properly.

You can check an example xls file enclosed

I would really appreciate any help.
Thanks in advance
(325.02 KiB) Downloaded 42 times

Return to “PowerPivot/DAX”

Who is online

Users browsing this forum: No registered users and 3 guests