Forum Discussion
Beginner Problem - Creat a Matrix Table for Salesperson with Direct And Indirect Sales Assigment
Hi DDFERRAR ,
According to your description, it sounds like parent child hierarchy related requirement. I'd like to suggest you look at the following blog if helps:
Parent-child hierarchies – DAX Patterns
Regards,
Xiaoxin Sheng
Hi DDFERRAR ,
According to your description, it sounds like parent child hierarchy related requirement. I'd like to suggest you look at the following blog if helps:
Parent-child hierarchies – DAX Patterns
Regards,
Xiaoxin Sheng
Hello @Xiaoxin Sheng, first of all let me thank yoI took a couple of days to understand the Parent-Child hierarcgies but it seams not to be the answer for what I need. Maybe I couldn figure that out but from what I undertand is that this is usuful to agregatte information in hierarchies for a certain columns (Ex; Total Sales sorted by Organization). What I need is something different beacuse I have a Purchase Order that has a Direct Assigment and an Indirect Assigment so I need to aggregate the Total Sales for each salesperson that appers either in direct or indirect assigment. Moreover this assigments are in two different colums so I do not understand how this hierarchy pattern could help- I could not find a way to create a key for each column and the associated hierarchy table. if you could provide and examplo related to your suggestion will be really appreciatted. The only was I could find a way was unpivoting this two colums and creating the grafics but I have duplicated values and unecessary date being showed. All the best!