I have a fact table that identifies active and terminated employees each month. The Active and Terminated measures are a sum of the column with a 0 or 1 populated. At the month level, this gives me the total active employees for the month and the terminated employees. When I roll up to the quarter, I want to continue to sum the terminated measure but average the active measure. I have entered avg(time.currentmember.children)in the quarter and year custom rollup formula and it does what I want for the active employees, but I am stuck with average terminations as well and I want actual counts. Please point me in the right direction.