Matrix group customers by size per salesperson with drillthrough

[mvhoffe]

Hello all,

I have been struggling with the following problem for a long time.

I have a list of customers, including the salesperson and turnover.

	Sales manager	Turnover
customer A	Sales manager 1	500
customer B	Sales manager 2	1000
customer C	Sales manager 3	1500
customer D	Sales manager 1	2000
customer E	Sales manager 3	6000
customer F	Sales manager 2	3000
customer G	Sales manager 1	3500

I would like to have a matrix with the following:

	Turnover < 1.000	Turnover 1.000 - 5.000	Turnover > 5.000
Sales manager 1	500	5500
Sales manager 2		4000
Sales manager 3		1500	6000

So, for example, in column 1,000 to 5,000 you will find the total turnover of relations that have a turnover between 1,000 and 5,000.

Now I have already succeeded to that extent by building a measure per turnover group and including it as a value in the matrix:

Only if I DrillThrough on a turnover group (for example the 5,500) then I also get the other groups:

	Turnover < 1.000	Turnover 1.000 - 5.000	Turnover > 5.000
Customer A	500
Customer D		2000
Customer G		3500

And that's not what I want. I want the Drill Through page to only take the values ​​of the group/column in question. I understand that I can also get this by having a separate DT page per group, but then you get so many DT pages.

Can you help me with this?

[Anonymous · Accepted solution]

Hi, @mvhoffe 

You can use a slicer in conjunction with drilling.

Or you can add the Sales manager field to the drilldown settings in the Visualizations Pane.

Best Regards,
Yang
Community Support Team

If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum