Drilldown Report not working with simple table using measures as columns

[commercial_user]

Hello,

I have a simple table that uses measures to calculate head count for each floor of a building. The floor field doesn't exist in the data so there is a measure that creates a distinct count of the emp id list them for each Business Unit. 

I have created a new tab that drill downs to a report that shows more information about each head count including details relating about project info , emp id , etc. 

My drilldown report (seperate tab) currently includes filter for business unit and the four floor measures as part of the filter. So when an individual selects the value 20 from Engineering and Floor1, and right clicks to drilldown on this cell this should return information relating to engineering in floor 1 for those 20 people. However the current drilldown is returning information across floor 1, floor2, floor3 , and floor 4 for engineering and does not filter out the measures.

Can anyone help with this so that the filter returns the values relating to the selection from the cell the user drilldowns to only?

Thank you,

Business Unit	Floor 1	Floor 2	Floor 3	Floor 4
Engineering	20	10	20	150
Finance	10	0	5	0
Marketing	80	0	0	0
Administration	20	5	10	5
Human Resources	5	0	20	1
Operations	0	10	200	5
NonClassified	10	40	5	8

[Anonymous · Accepted solution]

Hi @commercial_user 

Based on your descriotion, you need to create the field that contains the floor information, like the following table.

Then you should use the drill through , in another page, put the floor field to the drill through filter.

then when you drill throuth, it can work.

You can create a matrix visual, then put the following field to the visual.

Then click the floor1 and drill through.

Output

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[commercial_user]

Thank you for your response, I have a new issue now that I've assigned this new column I will post the link here shortly.

[Anonymous]

Hi @commercial_user 

If the solution I offered help you solve the problem, please consider to accept it as a solution so thar more user can refer to.

Best Regards!

Yolo Zhu