Tree Hierarchy drill down issue

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

Tree Hierarchy drill down issue

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

Hi,
Let's say I have 3 tables as below:

Sales
Products
Categories

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:
https://www.daxpatterns.com/parent-child-hierarchies


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
Attachments
example.xlsx
(325.02 KiB) Downloaded 42 times

Return to “PowerPivot/DAX”

Who is online

Users browsing this forum: No registered users and 3 guests

cron