Drill down inherits values, looking for help.

[TapZxK]

Hi Folks, 

I'm setting up this Project Performance Dashboad and I have run in to a problem with visaul. 

In this case I'm using The "Clustered Column Chart" To represent project Costs and Billings side by side. 

I have also enabled drill through option so that PM's can click on their project and see Total cost of PayRoll and Non Payroll and even further to see total cost of Each Person in that project. 

Now cost drilldown works fine, it automatically filters even down to specific employee costs. but what is hapenning is that it also next to the employee shows the TOTAL AMOUNT of BILLINGS. 

I have attached pictures for you to see the problem. 

My Drill-Through is set like this.

1. Project Group Level

2. Project Name Level

3. Cost Group (Payroll / Non Payroll) Level

4. Employee Enterprise ID Level

What I would like to have is so that Costs VS Billings are shown only on 1. Project Group and 2. Project Name sections, after that I would want only the costs to be seen without a comparison to Billings. So the problem is at steps 3 and 4 

I would greatly appreciate your help. 

1. Project Group Level2. Project Name Level3. Cost Group Level4. Employee Cost level

[jdbuchanan71 · Accepted solution]

Hello @TapZxK 

You can write a mesure that will check what level you are on and when you are at the Cost Group or Employee return blank otherwise return [Total Billed].

Total Billed Filtered =
IF ( ISINSCOPE ( TableName[Cost Group Field] ) || ISINSCOPE ( TableName[Employee Enterprise ID Field] ), BLANK(), [Total Billed] )

[TapZxK]

Thanks @jdbuchanan71 ,

worked like a charm. 

BR,

Kris