Same denominator for different row in Matrix Table

[anon__19]

Hi guys, need help on this.

I want to get the breakdown of leave percentage for mulltiple departments. However, the denominator changes after expanding to leave categories. The denominator should be static which is the total hours of the department per day.

Below is expected result:

_Leave% =

Var Leave_ = CALCULATE(SUM(Shrinkage[Planned Total]),FILTER(Shrinkage,Shrinkage[Shrink Type] = "Planned"))

Var unLeave_ = CALCULATE(SUM(Shrinkage[Unplanned Total]),FILTER(Shrinkage,Shrinkage[Shrink Type] = "Unplanned"))

VAR denom = [_Activity_Dur]

Return

    ((Leave_ + unLeave_) / denom)