DAX to count Gender for repeating row for each staff

[DavieJoe]

LOL…sorry, thought this was an Excel issue

Here is the DAX

Male Count =
CALCULATE ( DISTINCTCOUNT ( 'Table'[Employee ID] ), 'Table'[Gender] = "Male" )

Female Count =
CALCULATE ( DISTINCTCOUNT ( 'Table'[Employee ID] ), 'Table'[Gender] = "Female" )