Avoid Drill down % of

[mahmed1]

Hi

I have created a measure that gives a % score based on the row context

ie

Absence 25%
Comms 15%

I have created another table that breaks down the main categories further into sub categories eg

when absence is selected then it filter through other table

Sick 10%
long Sick 2% etc

my problem Is that when it drills through it’s gives the % of Absence
What I want to do is when Absence is pressed - give the % for the sub categories not as a % of the Absence etc

so current calc is Shrink % = Shrinktime/TotalTime