Are you trying to 'remove' (not take into account)
any [Create Date] & [Service Type] Dim values combination
that result in [Daily Average Duration] aggregate value
more than the Parameter threshold?
If yes, then both [Created Date] and [Service Type] Dimensions
should be included -- either on a view (as on the Sheet 7 workout)
or (and) in the calculations (as on the Sheet 7).
Besides, since both the Numerator and the Denominator are additive,
the last RUNNING_SUM() value is equal to the WINDOW_SUM() one,
hence the results.
Please find the attached.
Hope it could help.
TEST FILE_v10.5_YF.twbx 230.9 KB