Blank Totals row Matrix

[Anonymous]

I have create age bucket that count employees in to age groups.
But the total row is blank.

this is the Dax formula (measure)

Count_Employees =

VAR AgeStart =

    SELECTEDVALUE(agegroups[Min])

VAR AgeEnd =

    SELECTEDVALUE(agegroups[Max])

RETURN

    COUNTROWS(

        FILTER (

            VALUES ( Personalreport[employeeID]),

            [Dynamic age] > AgeStart

                && [Dynamic age] <= AgeEnd

        )

    ))

The Dynamic age is a measure that- calculate age based on Date Table selection.

Dynamic age = INT(YEARFRAC(SELECTEDVALUE(Personalrapport[Birthday),MAX(CalendarHR[Date])))z

This is the result

What do I have to do to get this to Sum Totals?

[UjjawalTyagi518]

hi @Anonymous,
if possible can you provide a sample or dummy file.
Thanks

[Anonymous]

Hi, I am sorry but that will require alot of work to remove personal information. I will see if I can make another file.